Registered aircraft · 85,620

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N1847YN1847y LLC · Queensbury, NYFirst renewal noticeBuilt 1962 · S/N 17249447 N18483F33a Holdings LLC · Woodbridge, VABuilt 1977 · S/N CE-735 N1848JFrozen Aero Enteprises LLC · Grand Forks, NDBuilt 1968 · S/N 28-24284 N1848QHartley Paul · Bellevue, WABuilt 1977 · S/N 18503493 N1848RTallman Dale C · Wasilla, AKBuilt 1974 · S/N 18502563 N1848WLee Clarence K · Colleyville, TXBuilt 1973 · S/N TC-1534 N1848XTeo Steel Inc · Ramer, TNBuilt 1981 · S/N E-1919 N1848ZBritt Robert J · Augres, MIBuilt 1962 · S/N 205-0048 N18496Willy P Air LLC · Fort Myers, FLBuilt 1977 · S/N E-1153 N18499Austin Aviation LLC · Boise, IDBuilt 1983 · S/N EA-362 N1849DBerka George · Wilmington, DEFirst renewal noticeBuilt 1952 · S/N D-3100 N1849FCrouse William F · Priest River, IDBuilt 1966 · S/N 21058749 N1849LSpillman George R Jr · Argyle, TXBuilt 1976 · S/N E-848 N1849PDaedalus LLC · Bozeman, MTBuilt 1982 · S/N CE-974 N1849SOnedown LLC · Kalispell, MTBuilt 1981 · S/N CE-973 N1849WCarrow LLC · Meredith, NHBuilt 1973 · S/N E-428 N1849XRaymond Patrick H · Jerseyville, ILBuilt 1965 · S/N 18255949 N184AJFour Alpha Juliet LLC · Minster, OHBuilt 2004 · S/N E-3578 N184AKDe Man Cameron T · Bend, ORBuilt 1963 · S/N 18051302 N184BWDevuono Derin D · Pocono Lake, PABuilt 1979 · S/N 28-7916345 N184CFPiper Aircraft Inc · Vero Beach, FLBuilt 1999 · S/N 2843242 N184DGMartin Vicente Eduardo Misa · Miami, FLBuilt 1964 · S/N 27-2504 N184DMRegistered aircraftBuilt 1998 · S/N E-3199 N184DPRobertson Gary B · Canton, TXBuilt 1975 · S/N 18263817 N184EHTen Hi Flyers Inc · Denver, COBuilt 1989 · S/N CE-1355 N184HPGries John R · Haslet, TXBuilt 1979 · S/N TC-2248 N184JDRegistered aircraftBuilt 1977 · S/N 28-7790567 N184JLPeters Bryan · Corpus Christi, TXBuilt 1963 · S/N 129 N184JPSarita Aerial Contractors Inc · Casa Grande, AZBuilt 1979 · S/N 18052889 N184LGAb Prop Plane I LLC · Metairie, LAS/N 2881908 N184MBBaker Aviation Consulting LLC · Summerland Key, FLBuilt 1976 · S/N TE-1075 N184PSStrama Aviation LLC · Ocala, FLBuilt 1965 · S/N 310J0111 N184PWCardwell Aubrey Lynn · Spring Branch, TXBuilt 1979 · S/N 18266871 N184QSchmuker David Joseph · Grand Rapids, MIBuilt 1959 · S/N D-5954 N184TCTexas State Technical College · Waco, TXBuilt 2025 · S/N 28020240 N184TMYates Christopher R · Huntington Beach, CABuilt 1956 · S/N 32302 N185Ellison Jeremy Trustee · Dayton, NVBuilt 1974 · S/N 18502582 N18500Thompson Dennis E · Anchorage, AKBuilt 1977 · S/N 18503305 N1850DLeupp John R · Taylors, SCFirst renewal noticeBuilt 1952 · S/N D-3116 N1850FMarcus Air LLC · Plano, TXBuilt 1981 · S/N TE-1195 N1850JWailea Aircraft LLC · Kamuela, HIBuilt 1981 · S/N EA-268 N1851HKoelsch Benjamin · Nome, AKS/N 28-7725163 N1851JSande 6 Aviation Inc · Wilmington, DEBuilt 1968 · S/N 28-24288 N1851YEscapule Dustin L III · Florence, AZBuilt 1962 · S/N 17249451 N18521Island Air LLC · Eagan, MNBuilt 1979 · S/N 185-03812 N1852DEbers Harold Dewayne · Hennessey, OKBuilt 1952 · S/N D-3114 N1852EMarshall Dennis Ray Jr · Pottsboro, TXS/N 310R1587 N1852FSymbot Management Inc · Dover, DENon-citizen corporation, flight hours not reportedBuilt 1966 · S/N 21058752 N1852HI Fly Stl LLC · Saint Louis, MOBuilt 1959 · S/N 35952 N1852JHanneman Robert · Denver City, TXS/N 28-24289

Back to AD 98-21-21 R1