Skip to content

Registered aircraft · 151

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-19-12-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:80-19-12-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:80-19-12-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:80-19-12-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:80-19-12-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:80-19-12-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.

N110SUAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-81 N117JASorbi Aviation Inc · El Cajon, CABuilt 1980 · S/N ME-282 N11VNHilton Head Flyers LLC · Liberty, SCBuilt 1981 · S/N ME-416 N137ASFlight Leasing Corp · Wilmington, DES/N ME-72 N141PNational Test Pilot School · Mojave, CABuilt 1979 · S/N ME-237 N158SQGriffith Aviation Inc · Griffith, INBuilt 1978 · S/N ME-86 N15USale Reported · Van Nuys, CASale reportedBuilt 1979 · S/N ME-160 N166ACAtlanta Aviation Academy Inc · Lawrenceville, GABuilt 1979 · S/N ME263 N176BCCousins Mark T · Portland, ORS/N ME-269 N18087Small Mountain Flyers LLC · West Monroe, LAS/N ME-415 N184ERIxi LLC · West Bloomfield, MIBuilt 1979 · S/N ME-267 N1850NSnohomish Flying Service Inc · Snohomish, WABuilt 1981 · S/N ME-429 N18929Vector Aviation LLC · Mentor, OHBuilt 1978 · S/N ME-6 N18941N18941 LLC · Boynton Beach, FLBuilt 1978 · S/N ME-8 N198CAKatla Aviation LLC · Atlanta, GABuilt 1980 · S/N ME-262 N19UBas Part Sales LLC · Greeley, COBuilt 1979 · S/N ME-294 N2007EWallbirds LLC · San Diego, CABuilt 1978 · S/N ME-60 N2007KExecutive Flight Institute LLC · Murrieta, CABuilt 1978 · S/N ME-55 N2008ESchrott Bradley S · Federal Way, WABuilt 1978 · S/N ME-73 N2009EAce Of Spades Aviation LLC · Las Vegas, NVS/N ME-61 N2009XGriffith Aviation Inc · Griffith, INBuilt 1978 · S/N ME-66 N2009YFancy Pants Aviation LLC · Fort Worth, TXBuilt 1978 · S/N ME-74 N20125New Horizon Aviation Inc · Warwick, RIBuilt 1978 · S/N ME-94 N2100DL A M Capital Management LLC · Sheridan, WYBuilt 1978 · S/N ME-41 N2265TOracle Aviation LLC · Omaha, NEBuilt 1980 · S/N ME-333 N24GMFive X Five Flight Inc · The Woodlands, TXBuilt 1981 · S/N ME-395 N256JD Gordon Aviation Inc · La Jolla, CABuilt 1978 · S/N ME-107 N25BMaine Instrument Flight · Augusta, MES/N ME-49 N269TUAero Quest LLC · Olive Branch, MSS/N ME-95 N26LMClassic Aviation Inc · Pella, IABuilt 1979 · S/N ME-177 N298BCFlight School Of Gwinnett · Lawrenceville, GABuilt 1978 · S/N ME-59 N312CMChristiansen Aviation LLC · Wilmington, DEBuilt 1978 · S/N ME-103 N329GBN329gb LLC · Chattanooga, TNBuilt 1978 · S/N ME-45 N3692XLake Elmo Aero LLC · Lake Elmo, MNBuilt 1981 · S/N ME-369 N3711NBay Area Concrete LLC · Hayward, CABuilt 1980 · S/N ME-375 N371AKSweeney James J III · Glenwood Springs, COBuilt 1979 · S/N ME-157 N3724BFlorida Flyers Flight Academy Inc · Saint Augustine, FLBuilt 1980 · S/N ME349 N3724HAviation Capital Management LLC · San Jose, CABuilt 1982 · S/N ME-350 N3728GDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N ME-357 N3733DSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1980 · S/N ME-362 N3733GPilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1980 · S/N ME-364 N3737UAirria Holdings LLC · BerlinBuilt 1980 · S/N ME-379 N3739QN3739q LLC · Colleyville, TXBuilt 1982 · S/N ME-378 N3803ESorbi Aviation Inc · El Cajon, CABuilt 1981 · S/N ME-381 N3812CChristiansen Aviation LLC · Wilmington, DES/N ME-390 N383Martis Valley Aviation LLC · Redwood City, CABuilt 1981 · S/N ME-388 N3839LFlight School Of Gwinnett · Lawrenceville, GABuilt 1981 · S/N ME-397 N42RRWalla Walla University · College Place, WAS/N ME-84 N444FEN444fe LLC · Stuart, FLBuilt 1979 · S/N ME-142 N456THB R S Leasing Inc · Wilmington, DEBuilt 1980 · S/N ME-319

Back to AD 80-19-12 R1