Registered aircraft · 40,472

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:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') 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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N2175UOptimus Aircraft Service Inc · Middletown, DEBuilt 1963 · S/N 337 N21764Blue Sky Flyers Inc · Evans, COFirst renewal noticeBuilt 1974 · S/N 17264010 N21769Overseas Aviation Inc · Wilmington, DEBuilt 1974 · S/N 17264013 N2176TSteeplechase LLC · Medfield, MABuilt 1971 · S/N 28-7205034 N2176XKnighten Daniel · Portland, ORBuilt 1979 · S/N 28-7990363 N21774Miller William A · Wallkill, NYS/N 17264016 N21779Tanner Johnathan E · Lancaster, CAS/N 1580 N2177CRenaissance General Restoration Contracting · Madera, CABuilt 1978 · S/N 17702747 N2177PMidwest Environmental Products Inc · Wichita, KSBuilt 1956 · S/N 23-783 N2177TRegistration Pending · Pine Mountain, GARegistration pending, pending cancellationBuilt 1971 · S/N 28-7205032 N21785Dibiaso Thomas F · Mount Laurel, NJBuilt 1974 · S/N 17264018 N2178CHowey Paul W · Stevensville, MDBuilt 1978 · S/N 17702748 N2178TOrban John J · Dewitt, MIBuilt 1971 · S/N 28-7205035 N2178WCarrillo Salvador Arias · Lompoc, CABuilt 1974 · S/N M-1522 N2178YN2178y LLC · Cumming, GABuilt 1979 · S/N 28-7990381 N21791Colson Kevin A · Andover, KSBuilt 1974 · S/N 17264021 N21799Brownell John P Jr · Prattville, ALBuilt 1974 · S/N 17264025 N2179TKroeger William R · Plattsmouth, NEBuilt 1972 · S/N 28-7205024 N2179UFlorea Byron · Carencro, LABuilt 1963 · S/N 341 N217AWHobart Aviation Inc · Akron, OHS/N 28-7125332 N217JAFlying Colors Airparts Inc · Leesburg, FLS/N 17275623 N217JBMccoy Robert G Jr · Marshville, NCBuilt 2002 · S/N 5122 N217LMCanada Christopher W · Freeport, FLBuilt 1966 · S/N 28-21972 N217SLegacy Leasing Group Inc · Wilmington, DEBuilt 2003 · S/N 05 N21802Owen Michael C · Seaside, CABuilt 1978 · S/N 28-7990059 N21803Morgan Edward · Gaithersburg, MDBuilt 1978 · S/N 28-7990060 N21804Sharpe Alexander F · Camarillo, CABuilt 1974 · S/N 17264026 N21809Eckerson Dean H · Benicia, CABuilt 1974 · S/N 17264028 N2180EInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 28-7916165 N2180RRoan Paul J · Clive, IABuilt 1969 · S/N 28-5479 N2180TDe Bella Richard M Sr · Blackwood, NJBuilt 1971 · S/N 28-7205027 N2180WGerges Amir · Arlington, TXS/N M-1563 N2180YAstro Aviation LLC · Cross Plains, TNBuilt 1979 · S/N 28-7990383 N21819Middlesex Aviation Partners LLC · Bellingham, MABuilt 1974 · S/N 17264029 N2181BJao Robert V · Kailua, HIBuilt 1978 · S/N 28-7916114 N2181TAdk Flying Club Inc · Ballston Spa, NYBuilt 1971 · S/N 28-7205036 N2182BFlying 20 Club Inc · Springfield, ILBuilt 1978 · S/N 28-7990124 N2182CSkyhunter LLC · Yonkers, NYS/N 17702749 N2182QCassett Terry D · Mankato, MNBuilt 1979 · S/N 28-7990297 N2183CVaughn Michael A Jr · Oxford, MIBuilt 1978 · S/N 17702750 N2183DLyons Terry L · Springfield, ILBuilt 1978 · S/N 28-7990163 N2183TSkies Unlimited LLC · Clinton Township, MIBuilt 1971 · S/N 28-7205026 N21840Erickson Arnold F · Devils Tower, WYBuilt 1974 · S/N 17264031 N21841Erlinger Ronald W · Wickenburg, AZBuilt 1974 · S/N 17264032 N2184BPlane Nonsense Inc · Middletown, DEBuilt 1978 · S/N 28-7990125 N2184TFisher Global LLC · Conway, ARBuilt 1971 · S/N 28-7205028 N21857Top Air · Salt Lake City, UTBuilt 1978 · S/N 28-7990062 N2185BHeirborne Again LLC · West Bridgewater, MABuilt 1978 · S/N 28-7990126 N2185EMckenzie Owen R Jr · Burlington, NCBuilt 1978 · S/N 17271182 N2185WHoward Pamela A · Goldthwaite, TXBuilt 1974 · S/N MB-696

Back to AD 80-04-03 R2