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.

N2363DCross John P · Houston, TXBuilt 1952 · S/N 20515 N2363FColumbus State Community College · Columbus, OHBuilt 1964 · S/N 21058563 N2363GSawaya Mark C · Spring Valley, CABuilt 1958 · S/N 51663 N2363RVertikle Enterprises LLC · Cheyenne, WYBuilt 1964 · S/N 18255463 N2363USyracuse Flying Club Inc · Fayetteville, NYBuilt 1979 · S/N 28-7911306 N2363XShort Joe · Clintwood, VABuilt 1965 · S/N 18256263 N23642Samson Motors Inc · Redmond, ORBuilt 1977 · S/N CE-759 N2364CMeinershagen Charles I · Redding, CABuilt 1953 · S/N 30664 N2364FCarlson David G Trustee · Cape Fair, MOBuilt 1964 · S/N 21058564 N2364GTveitnes Svein T · Whitewright, TXBuilt 1958 · S/N 51664 N2364RRegistered aircraftBuilt 1964 · S/N 18255464 N2364TVintage Aero Club · Smoketown, PABuilt 1971 · S/N 28-7225055 N2364XElkhorn Aviation LLC · Norfolk, NEBuilt 1965 · S/N 18256264 N23653Gales Charles R · Cleverdale, NYBuilt 1968 · S/N 28R-30691 N2365CStrolin LLC · Maple Valley, WABuilt 1978 · S/N R18200162 N2366CKase Gayle L · Wasilla, AKBuilt 1953 · S/N 30666 N2366DSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1952 · S/N 20518 N2366WAir-Mods Flight Academy · Robbinsville, NJS/N 28-8516046 N23674Siebenhaar Harold J · Los Altos, CAS/N D-10146 N2367DBushey Abel · Barnet, VTBuilt 1952 · S/N 20519 N2367GSahagun Salvador G · Bothell, WAS/N 51667 N2367PCrowley Steven J · Burlington, IABuilt 1981 · S/N TC-2367 N2367ZBrookie Aircraft LLC · Methuen, MABuilt 1979 · S/N 27-8054027 N23682Next Century Aviation Oregon LLC · Sausalito, CABuilt 1978 · S/N E-1205 N23685Clements Dennis · Chapel Hill, NCBuilt 1978 · S/N D-10099 N2368UPlehn Thomas R · Las Vegas, NVBuilt 1962 · S/N 17249968 N2368XD C T LLC · Wallace, IDBuilt 1965 · S/N 18256268 N2369CBlackert Charles M · Delaware Water Gap, PABuilt 1954 · S/N 30669 N2369DAbbott Dylan L · Lompoc, CAS/N 20521 N2369GPeter Travis E · Casper, WYBuilt 1958 · S/N 51669 N2369UMahoney Brandon M · Laurelville, OHS/N 17249969 N2369XChristiansen Aviation LLC · Wilmington, DEBuilt 2011 · S/N 4496291 N236AMyotis Ltd · Leesburg, VABuilt 1973 · S/N 18262695 N236ABOdonnell William J · Hampton, NHBuilt 1979 · S/N 28-7911151 N236AFAero Fisheries Inc · Fort Pierce, FLBuilt 1976 · S/N 17267726 N236AGTroposphere Ventures LLC · Fond Du Lac, WIBuilt 1978 · S/N R18200788 N236BEMcgill Benjamin D · Larchmont, NYBuilt 1981 · S/N E-1825 N236BHEagle Aero L L P · Carlsbad, NMBuilt 1978 · S/N 28-7911023 N236BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010037 N236CFGriswold Joshua P · Los Angeles, CABuilt 1976 · S/N 34-7770091 N236CHGta Air Inc · Addison, TXBuilt 1973 · S/N E-502 N236CTCostanzo Ralph R · Virginia Beach, VABuilt 1968 · S/N E-51 N236DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843824 N236DAFalany Curtis E · Tallahassee, FLBuilt 1966 · S/N 17254466 N236EKKloss Erik A · Livingston, TXS/N 28-7911083 N236FYSpace Coast Aircraft Co · Merritt Island, FLBuilt 2000 · S/N 2842023 N236HPProctor John M · Spotsylvania, VABuilt 1987 · S/N E2399 N236JAT & S Gentile Inc · Wintersville, OHBuilt 1981 · S/N 28-8211005 N236JEGunnels Farms Inc · Amarillo, TXS/N TC-2092 N236JMBloomfield Zachary · Chillicothe, OHS/N 28-8511019

Back to AD 98-21-21 R1