Registered aircraft · 85,612

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.

N267AGSimply Living LLC · Fort Myers, FLBuilt 1974 · S/N 28-7425114 N267CFBarks Kevin L · Dexter, MOS/N D-668 N267DHInternational Air Services Inc Trustee · Carson City, NVBuilt 1982 · S/N 28-8190141 N267DPCarrasco Mario G · Glendora, CABuilt 1967 · S/N 28-22673 N267JSDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1976 · S/N 347670332 N267LMAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N P21000362 N267MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881365 N267NDPlane Nonsense Inc · Middletown, DEBuilt 1999 · S/N 2842067 N267PDWhite Hat Repair LLC · Greenleaf, IDBuilt 1967 · S/N TE-284 N267RAReynolds Darryl G · Wills Point, TXS/N 17261919 N267RBLearn To Fly LLC · Portal, GABuilt 1967 · S/N 32-40261 N267WSErvin Andrew · Centennial, COBuilt 1966 · S/N 1000 N2680FWatkins Jeffrey M · Auburn, CABuilt 1965 · S/N 18256780 N2680GTodd Larry D · Wasilla, AKBuilt 1959 · S/N 51980 N2680MRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1977 · S/N 28-7890261 N2680QTaylor Clarence J · Pipestone, MNBuilt 1977 · S/N 32R-7780261 N2680TAviyon Aviation LLC · Orlando, FLBuilt 1971 · S/N 28-7225085 N2680WNielson Michael James · Spanish Fork, UTBuilt 1966 · S/N 1001 N2680YReid Brian M · Boise, IDBuilt 1962 · S/N 18051180 N2681GRhea Higher Education And Aviation LLC · Prescott, AZBuilt 1959 · S/N 51981 N2681TFetty Eric · Burleson, TXBuilt 1971 · S/N 28-7210003 N2681UOsterhaus Jonathan · Petersburg, TNBuilt 1963 · S/N 17250281 N2681WAb Mooney LLC · Durham, NCBuilt 1966 · S/N 3319 N2681XZimmer Roy E Jr · Winter Park, FLBuilt 1965 · S/N P206-0181 N2682AAnacortes Associates LLC · Anacortes, WABuilt 1969 · S/N D-9045 N2682GFlying L Aircraft Inc · Fort Denaud, FLBuilt 1959 · S/N 51982 N2682LCommonwealth Technical Services Inc · Powhatan, VABuilt 1967 · S/N 17255882 N2682RRadeka Michael · East Machias, MES/N 18258382 N2682TMorrison James S · Bergen, NYBuilt 1971 · S/N 28-7225086 N2682UCseh Sandor · New Brunswick, NJBuilt 1963 · S/N 17250282 N2682VVogen Jeffrey L · Newark, ILBuilt 1948 · S/N 18193 N2683CGrigg Charles G · Pasco, WABuilt 1978 · S/N R18200211 N2683DRasmussen Merlin P · Enumclaw, WABuilt 1952 · S/N 20835 N2683GEtc Aircraft LLC · Anchorage, AKFirst renewal noticeS/N 51983 N2683RNance James H II · Grants Pass, ORBuilt 1967 · S/N 18258383 N2683TSojourn Flyers Inc · Chebanse, ILBuilt 1971 · S/N 28-7205082 N2683WSabagh Steve B · Maricopa, AZBuilt 1966 · S/N 1002 N2684DSaltsgaver Robert E III · Maryville, TNS/N 20836 N2684FFelts Anthony E · Groveland, CAS/N 18256784 N2684QJastram Benjamin C · Lafayette, LABuilt 1966 · S/N 18257884 N2684TGallaher Matthew · Anchorage, AKBuilt 1971 · S/N 28-7225087 N2684UAnderson Robert David · Brighton, MIBuilt 1963 · S/N 17250284 N2685FBabovic Slobodan · Elm Grove, WIBuilt 1965 · S/N 18256785 N2685QMcelmoyl John W · Greenfield, CABuilt 1966 · S/N 18257885 N2685XWorden Andrew · Burlington, COS/N 18255311 N26865Coastline Bonanza LLC · Bedford, NHBuilt 1986 · S/N E-2319 N2686FKing Cara Jean · Deland, FLBuilt 1965 · S/N 18256786 N2686QLines Daniel R · Roseburg, ORBuilt 1966 · S/N 18257886 N2686TGoddard John · Penokee, KSBuilt 1971 · S/N 28-7205083 N2686USzalay Jamey R · Princeton, NJBuilt 1963 · S/N 17250286

Back to AD 98-21-21 R1