Registered aircraft · 18,497

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

N6779BRegistered aircraftBuilt 1978 · S/N 21062829 N677CAHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0631 N677CDInternational Air Services Inc Trustee · Carson City, NVBuilt 2004 · S/N 1081 N677JLInternational Air Services Inc Trustee · Carson City, NVBuilt 2026 · S/N E-4168 N677MBChaves Carlos A · San Juan, PRFirst renewal noticeBuilt 2004 · S/N 0799 N677ZMottram Jacob A · Orange, CABuilt 1965 · S/N TE-14 N6780RC2 Aero LLC · Dallas, TXBuilt 1966 · S/N T210-0180 N6782RReavis Paul B · Gatesville, TXBuilt 1966 · S/N T210-0182 N6783RHarness Jesse J · Peoria, AZBuilt 1966 · S/N T210-0183 N6784RVolk Kenneth L · Waskom, TXBuilt 1966 · S/N T210-0184 N6785RRood Enterprises LLC · Livingston, TXBuilt 1966 · S/N T210-0185 N67886Hyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0435 N6788CDewn Aviation LLC · Noble, OKFirst renewal noticeBuilt 1983 · S/N E-2090 N6789RDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N T210-0189 N6789YMcdonough Patrick J · Defiance, OHBuilt 1986 · S/N EA-453 N678BKRobco Engineering LLC · Sarasota, FLBuilt 2026 · S/N E-4165 N678CDFrogman Flight Ops LLC · Wilmington, DEBuilt 2005 · S/N 1410 N678CTSanborn Thomas W · College Station, TXBuilt 1978 · S/N P21000019 N678DBGolden Eagle Flight LLC · Farmington, UTBuilt 1975 · S/N 421B0876 N678DFForney Dylan · Murchison, TXBuilt 2001 · S/N 0125 N678EMAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1978 · S/N E-1285 N678FChapel On The Bayou Ministries LLC · Raceland, LABuilt 1969 · S/N TE-687 N678HDawson Aircraft Inc · Clinton, ARBuilt 1981 · S/N 414A0678 N678HCMckisson Holdings LLC · Renton, WABuilt 1980 · S/N EA-180 N678JInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N TH821 N678JREberhardt John R Jr · Katy, TXBuilt 1977 · S/N D-10095 N678JSGolden Pegasus LLC · Hughson, CABuilt 1978 · S/N 414A0090 N678MJPiasa LLC · Pacific, MOBuilt 1979 · S/N 79-30941 N678PCComplete Rv LLC · Kalispell, MTBuilt 2001 · S/N 0104 N678SLVolunteer Aviation LLC · Resaca, GABuilt 2015 · S/N E-4068 N678ZBas Part Sales LLC · Greeley, COBuilt 2002 · S/N 0311 N67909Hyannis Air Service Inc DBA · Hyannis, MABuilt 1981 · S/N 402C0449 N6792GGrimmett Donna G · Tomball, TXS/N 29-0012 N6793RDelevie Mark Y · Tucson, AZBuilt 1966 · S/N T210-0193 N6797RJts Management Inc · Lincoln, NEBuilt 1966 · S/N T210-0197 N6797YFar West Ranches Inc · Brawley, CABuilt 1995 · S/N E-2974 N6798VGaylord Hangars LLC · Gaylord, MIBuilt 1982 · S/N 421C1254 N679KTJjel LLC · Wilmington, DEBuilt 2016 · S/N TH-2457 N679LMLone Mountain Aircraft LLC · Vandalia, OHBuilt 2005 · S/N 1679 N67ALAlan Gaudenti · Groveland, CABuilt 1988 · S/N E-2420 N67BL206 LLC · Keizer, ORBuilt 1967 · S/N P206-0397 N67CDAspen Aircraft LLC · Oklahoma City, OKS/N E-2554 N67CHPrestige Aviation LLC · Lake Havasu City, AZBuilt 1981 · S/N 21064354 N67DFSusens Dennis W · Columbia Falls, MTBuilt 1998 · S/N 98191 N67DGD&B Aircraft Leasing LLC · Anchorage, AKBuilt 1974 · S/N U20602375 N67DRLarson Jeffrey · Spearfish, SDS/N D-9772 N67DSHangar 39 LLC · Culpeper, VAS/N A185E1284 N67EPViner Kevin Patrick · Encinitas, CAS/N P21000032 N67ERWhitfield Michael L · Leander, TXBuilt 1976 · S/N TJ-43 N67GXDivision Of Aerodynamics LLC · Littleton, COBuilt 2005 · S/N 29-0344

Back to AD 86-13-04 R3