Registered aircraft · 20,687

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N978SPLlp Leasing Group LLC · Lewes, DEBuilt 1999 · S/N 172S8181 N9790GIsaac Gerald B · Spencerport, NYBuilt 1979 · S/N 17273636 N97919Christiansen Aviation LLC · Wilmington, DEBuilt 1984 · S/N 17276239 N9791BHicks Keith · Sweetwater, TNS/N 172RG1039 N9791FRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1997 · S/N 17280062 N97921Flywell Aviation LLC · Bowling Green, KYS/N 17276240 N9792VHavu Aviation LLC · Irvine, CABuilt 1974 · S/N 17264504 N97945Kent State University · Stow, OHBuilt 1984 · S/N 17276241 N97947Civil Air Patrol · Maxwell Afb, ALBuilt 1984 · S/N 17276242 N9794VCooke George C IV Trustee · Richland, WABuilt 1974 · S/N 17264505 N9795BSilver Express Co DBA · Miami, FLNon-citizen corporation, flight hours not reportedBuilt 1982 · S/N 172RG1042 N9795TWhite Cap Aviation LLC · Amsterdam, NYS/N 47595 N9796VKelley Aircraft LLC · Weyers Cave, VAS/N 17264506 N9797TBasham James L · Livingston, TXS/N 47597 N97984Woody George R · Clinton, ARBuilt 1984 · S/N 17276244 N9798TRegistered aircraftBuilt 1960 · S/N 47598 N9799TDeapen Jordan Derek · Clifton, TXBuilt 1960 · S/N 47599 N979BCMacinnis Charles E · Harbor Springs, MIBuilt 1997 · S/N 17280060 N979BVTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13490 N979CPCivil Air Patrol Inc · Maxwell Fb, ALBuilt 1997 · S/N 17280210 N979EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S13019 N979JFGoodspeed Air Service LLC · Oxford, CTBuilt 1966 · S/N 17254071 N979PTCappe Ivestment Group LLC · Homestead, FLBuilt 1974 · S/N 17264503 N979WDDolphin Leasing LLC · Daytona Beach, FLBuilt 2005 · S/N 172S10077 N97ATRainier Flight Service LLC · Renton, WABuilt 2005 · S/N 172S9853 N97BSSidewinder Services LLC · Genoa, NVBuilt 1973 · S/N 17262475 N97FFPeregrine Howard Fund V Owner LLC · New Orleans, LABuilt 2024 · S/N 172S13207 N97FRSmith Ralph E · Lyndonville, NYBuilt 1980 · S/N 17274188 N97JBVieira Nunes Da Silva Raphael · Ethel, LABuilt 1966 · S/N 17255305 N97LFSpengler Raymond Francis Jr · Longview, TXBuilt 1997 · S/N 17280286 N97MWRudderworks Aviation LLC · Fairfax Station, VABuilt 1975 · S/N 17264946 N97PDBoeing Employees Flying Association Inc · Renton, WABuilt 2000 · S/N 172S8392 N97VACamps Bay Aviation LLC · Waukegan, ILBuilt 2005 · S/N 172S9906 N9800THerr Garrick D · Wasilla, AKBuilt 1960 · S/N 47600 N9801GTriad Aviation Academy LLC · Greensboro, NCS/N 17259701 N9802TSandford Graves M · Moberly, MOS/N 47602 N9803CWhite Traci M · Manasquan, NJBuilt 1971 · S/N 17259703 N9804TRussell Michael K · Sprakers, NYBuilt 1960 · S/N 47604 N9805GSell Edwin D · Woodbury, PABuilt 1971 · S/N 17259705 N9805TNorman Ronald E · Lopez Island, WABuilt 1960 · S/N 47605 N9806GDonohue Denis J · Montvale, NJBuilt 1971 · S/N 17259706 N9807GPoshak Jay M · Ely, MNS/N 17259707 N9808JPtosis LLC · Fair Oaks, CABuilt 1980 · S/N 17273919 N9808TGilmer Randy G · Nickelsville, VABuilt 1960 · S/N 47608 N9809GMcclendon Jon L · Kilgore, TXBuilt 1971 · S/N 17259709 N980CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280213 N980SPFisher Stables And Arena Inc · Gladewater, TXBuilt 1999 · S/N 172S8182 N980TAFierling Lennard W · Colton, ORBuilt 1961 · S/N 17248800 N9810GAir America Flight Center LLC · Daytona Beach, FLBuilt 1971 · S/N 17259710 N9810TWall Jeffrey L · Goffstown, NHBuilt 1960 · S/N 47610

Back to AD 90-06-03 R1