Skip to content

Registered aircraft · 40,473

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.

N7327DFrankfort Flying Club Inc · Beulah, MIBuilt 1957 · S/N 22-5115 N7327FAirconrad LLC · Duncansville, PAS/N 28-25236 N7327JWhite Benjamin M · Hallsville, TXBuilt 1968 · S/N 28-24681 N7327WCerto Russell · Grand Island, NYBuilt 1963 · S/N 28-1198 N73289Correggio James · Shapleigh, MEBuilt 1976 · S/N 17267346 N7328GShort Larry D DBA · Allen, KYBuilt 1970 · S/N 17259028 N7328JNightline Air LLC · Saratoga Springs, UTBuilt 1968 · S/N 28-24682 N7328PCoffee Bean Connoisseur LLC · Highland, NYBuilt 1961 · S/N 24-2506 N73293Shawano Flying Service Inc · Shawano, WIBuilt 1976 · S/N 17267349 N73294G And G Maintenance Corp · Miami, FLBuilt 1976 · S/N 17267350 N73295Whitten Chris D · Townville, SCBuilt 1976 · S/N 17267351 N73296Han Farms Inc · Inverness, MTBuilt 1976 · S/N 17267352 N73298Castelan Luis E · Irving, TXBuilt 1976 · S/N 17267354 N7329DCampbell Michael S · Ann Arbor, MIS/N 22-5117 N7329FProflite Aero LLC · Easton, PABuilt 1968 · S/N 28-25237 N7329GFive Guys Aviation LLC · Pendleton, SCBuilt 1970 · S/N 17259029 N7329JWalser Air LLC · Warwick, RIBuilt 1968 · S/N 28-24683 N7329WHohl Warren G · Albany, GABuilt 1963 · S/N 28-1200 N732ACaraway Michael S · Decatur, TXBuilt 1993 · S/N 20321 N732BNConn Teresa M · Fairfax, VABuilt 1960 · S/N 252 N732JBHenry Sean M · Savannah, GABuilt 1998 · S/N 60031 N732WDBig Picture Aviation Inc · Wheaton, ILBuilt 1980 · S/N 172RG0264 N73306Boomer Aviation Inc · Fort Walton Beach, FLBuilt 1976 · S/N 17267361 N73307Ftk Aviation LLC · Evans, GABuilt 1976 · S/N 17267362 N7330KFinke Michael C · Sewickley, PABuilt 1950 · S/N 20-231 N7330WAdventist World Aviation · Wilson, NCFirst renewal noticeBuilt 1963 · S/N 28-1201 N73311184 Flying Club Inc · Concord, CABuilt 1976 · S/N 17267364 N73312Murray Air LLC · Patoka, ILBuilt 1976 · S/N 17267365 N73317Bell Susan J · Georgetown, CABuilt 1976 · S/N 17267368 N73318Lair De Rien Aviation Inc Trustee · Wilmington, DEBuilt 1976 · S/N 17267369 N73319My Way Aviation LLC · Weston, FLBuilt 1976 · S/N 17267370 N7331FGreenwood Stephen R · Salt Lake City, UTBuilt 1968 · S/N 28-25238 N7331JRitchey David C · Hilliard, OHBuilt 1968 · S/N 28-24685 N7331WBandit Aviation LLC · Batesville, MSBuilt 1963 · S/N 28-1091 N73321Learn To Fly Nola LLC · New Orleans, LABuilt 1976 · S/N 17267372 N73324Gulf Atlantic Airways DBA · Gainesville, FLBuilt 1976 · S/N 17267374 N7332JRegistration Pending · Peculiar, MORegistration pendingBuilt 1968 · S/N 28-24686 N7332PArnold Christian M · Waltham, MABuilt 1961 · S/N 24-2511 N7332WBarney Steven K · Bloomfield, NEBuilt 1963 · S/N 28-1202 N7332ZHaggland James R · Fairbanks, AKBuilt 1966 · S/N 18-8401 N73330Thornton Ralph · Oxford, ALBuilt 1976 · S/N 17267378 N73331Dameron Cleveland F · Wicomico Church, VABuilt 1976 · S/N 17267379 N73334Heavy Metal Air LLC · Farmingdale, NYBuilt 1976 · S/N 17267382 N73338Einarson Flying Service · Intl Falls, MNS/N 17267386 N7333FHickle William H · Inyokern, CAS/N 17273246 N73345N73345 Aviation LLC · Sheridan, WYBuilt 1976 · S/N 17267390 N7334FWings Flight Enterprises Inc · Danville, KYBuilt 1979 · S/N 17273247 N7334GEllis Gregory D · Winnsboro, TXBuilt 1970 · S/N 17259034 N73354Sky Partners LLC · Sylacauga, ALBuilt 1976 · S/N 17267396 N73357Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1976 · S/N 17267398

Back to AD 80-04-03 R2