Registered aircraft · 40,471

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.

N9610UMaschek Anthony Q · Harker Heights, TXBuilt 1975 · S/N AA5-0810 N9611CSamrat Prithviraj Inc · Miami, FLBuilt 1997 · S/N 1 N9611JStull Donald K · Catawba, NCBuilt 1966 · S/N 28-3761 N9611UKingsley Paul A II · Idledale, COBuilt 1975 · S/N AA5-0811 N9612DSoto Edward · Wasilla, AKBuilt 1958 · S/N 22-6522 N9612HRegistration Pending · Ocean Isle Beach, NCRegistration pendingBuilt 1975 · S/N 17266263 N9612JReich Gregory N · Schwenksville, PABuilt 1966 · S/N 28-3810 N9612UElizabeth B Hawley · Wichita Falls, TXBuilt 1975 · S/N AA5-0812 N9612WJama Aviation LLC · Blaine, MNBuilt 1967 · S/N 28-23066 N9613HFiedler Mark · Wichita, KSBuilt 1975 · S/N 17266264 N9613JKraun Fred M · Fall City, WABuilt 1966 · S/N 28-3766 N9613UGlenn Thomas Joel Hr · Fort White, FLS/N AA5-0813 N9613WAir Wilma LLC · Tijeras, NMS/N 28-23067 N9614EWeber William J · Durham, NCBuilt 1991 · S/N 1179 N9614HC&H Elite Air LLC · Johnstown, COBuilt 1975 · S/N 17266265 N9614JSkinner Roger · Delanson, NYBuilt 1966 · S/N 28-3767 N9614QConrad Terry E · Lancaster, OHBuilt 1975 · S/N 17265699 N9614SFlatonia Veterinary Clinic Inc · Flatonia, TXBuilt 1966 · S/N 46 N9614WByrne Matthew A · West Allis, WIBuilt 1967 · S/N 28-23069 N9615DPeterson Thomas M · Park Rapids, MNBuilt 1959 · S/N 22-6525 N9615RAlbright Frank · Elba, ALBuilt 1991 · S/N 1185 N9615UKnutson Duane G · Brookings, SDBuilt 1975 · S/N AA5-0815 N9616ABoyd Ronald J · Genoa, COBuilt 1990 · S/N 1170 N9616JGarsteck Paula · Put In Bay, OHBuilt 1966 · S/N 28-3769 N9616LMid Island Air Service Inc · Ronkonkoma, NYBuilt 1986 · S/N 17276590 N9616QClearview Flying Club Inc · Westminster, MDBuilt 1975 · S/N 17265701 N9616RPray Aviation Inc · Augusta, KSS/N TD-295 N9616WKohut Jeanette G · Southern Pines, NCBuilt 1967 · S/N 28-23071 N96177B2 Cpr Plus Inc · Bermuda Dunes, CABuilt 1970 · S/N 17701543 N9617DWinton Christopher M · Valley Center, KSBuilt 1958 · S/N 22-6528 N9617HShinn Lake D · Stevensville, MTBuilt 1976 · S/N 17266267 N9617JBeaverdam Aeronautics LLC · Chatom, ALBuilt 1966 · S/N 28-3771 N9617QKagin Corp · Wilmington, DEBuilt 1975 · S/N 17265702 N9617WPoskevich Douglas P · Deland, FLS/N 28-23072 N96180Jb Aviation · Bolingbrook, ILBuilt 1983 · S/N 17276034 N9618DRich Beryl G · Brush Prairie, WABuilt 1958 · S/N 22-6529 N9618UN9618u LLC · Grand Haven, MIBuilt 1975 · S/N AA5-0818 N96192Hannah Charles B · Skiatook, OKBuilt 1983 · S/N 17276039 N9619BEuroaviation Inc Trustee · KematenBuilt 1981 · S/N 172RG0924 N9619DSciotti Michael V · Wasilla, AKBuilt 1958 · S/N 22-6530 N9619JFlick Kristina R · Port Ewen, NYBuilt 1966 · S/N 28-3773 N9619SCulp Barney L Jr · Emerald Isle, NCBuilt 1965 · S/N 13 N9619WId Rather Knot LLC · Louisville, KYBuilt 1967 · S/N 28-23075 N961CLRegistration Pending · North Las Vegas, NVRegistration pendingBuilt 1986 · S/N 0594 N961DACondair Flyers Inc · Latham, NYBuilt 1996 · S/N 2843034 N961DJSeibly Larry · Mckinney, TXBuilt 1960 · S/N 24-1955 N961DMFlying Tigers Flight School LLC · Houston, TXBuilt 1976 · S/N AA5B0392 N961JJButler James C · Wharton, TXS/N 20879 N961RSJames River Pitts LLC · Yorktown, VABuilt 1978 · S/N 1001 N961SSAdams Criss E · Wasilla, AKBuilt 1996 · S/N 96-I

Back to AD 80-04-03 R2