Skip to content

Registered aircraft · 20,486

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N127CFGeorgia Forestry Commission · Macon, GABuilt 2007 · S/N 18282027 N127DDKimberlin Mark · Grants Pass, ORS/N 7040 N127ETThomas Eric C · Boise, IDBuilt 1982 · S/N 18268234 N127GMCorn Alley Aviation LLC · El Paso, ILBuilt 1949 · S/N 7411 N127RLSkylane Of Ohio LLC · London, OHS/N 18262910 N127SLGulf Coast Helicopters Inc · Pearland, TXBuilt 2003 · S/N 18281256 N127TJRegistration Pending · Bowersville, GARegistration pendingBuilt 1978 · S/N 18266629 N127VCSmith Von T · Chelan, WABuilt 1967 · S/N 18258041 N1281SChief Cornerstone LLC · Billings, MTBuilt 1976 · S/N 18264849 N1284TWhite Wayne A · Loyalton, CABuilt 1959 · S/N 52016 N1288SFrench Oil Co · Midland, TXBuilt 1976 · S/N 18264855 N1289UKavak Air Inc · Middletown, DEBuilt 1982 · S/N 21064682 N128BWRodriquez Roy L DBA · Martin, TNBuilt 1969 · S/N 18260080 N128JRMorris Dylan L · Garden Plain, KSBuilt 1976 · S/N 18264785 N128SWRegistered aircraftBuilt 1966 · S/N 18051699 N128TTWarner Wings LLC · Yakima, WABuilt 1979 · S/N U20604991 N1290FKilm LLC · Wilmington, NCBuilt 2007 · S/N 18282045 N1290KN1290k LLC · Dover, DEBuilt 1965 · S/N 18256650 N1290MGardner Michael John · Ashland, ILBuilt 1975 · S/N 18264275 N1291MCon Air Aviation LLC · Westerville, OHBuilt 1975 · S/N 18264276 N1291PPowers Elbie L · Roseboro, NCBuilt 1965 · S/N 18256573 N1291SAvidyne Corp · Melbourne, FLBuilt 1976 · S/N 18264858 N1292MCool Change Rentals LLC · Beaufort, NCBuilt 1975 · S/N 18264277 N1293SMeyer Raymond · Belding, MIBuilt 1976 · S/N 18264860 N1294SSheehan Dennis M · Stoughton, WIBuilt 1976 · S/N 18264861 N1297SAlpine Skylane LLC · Alpine, WYS/N 18264864 N1298MRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1975 · S/N 18264280 N1298SHighlane LLC · Phoenix, AZBuilt 1976 · S/N 18264865 N1299MMoanaviation Inc · Tampa, FLBuilt 1977 · S/N 21061932 N1299SAero Guard Aviation Insurance LLC · Lincoln, NEBuilt 1976 · S/N 18264866 N129BAAdvise By Air LLC · Whittier, CABuilt 2004 · S/N 18281353 N129CSGoldenstein Steven H Jr · Jurupa Valley, CABuilt 1975 · S/N 18264167 N129ELTrooien-Smith Construction LLC · Seeley Lake, MTBuilt 1978 · S/N U20604374 N129JAWhite River Holdings LLC · Hernando, MSBuilt 2022 · S/N 18283172 N129JTNiles Air LLC · Concord, NCBuilt 2024 · S/N 18283288 N129SEBarrington Air Inc · Littleton, COBuilt 1998 · S/N 18280384 N129VRecovery One Services LLC · Georgetown, KYBuilt 1979 · S/N 18267444 N12AWTgam LLC · Toppenish, WABuilt 1978 · S/N U20604688 N12BCCentral Ohio Flyers Assn · Columbus, OHBuilt 1973 · S/N 18261895 N12CHKetchum Christensen Sky Chasers LLC · Midwest City, OKBuilt 1966 · S/N 18257291 N12DUWoodtick Summit Aviation LLC · Redmond, ORBuilt 1979 · S/N U20605202 N12EEArizona Cloudbusters Inc · Mesa, AZS/N 18280038 N12FJClement Nicolas · Littleton, MABuilt 1973 · S/N 18261732 N12GZBoettcher Aerial Co Inc · Beloit, KSBuilt 1974 · S/N 18801619 N12HPState Of Ohio · Columbus, OHBuilt 2002 · S/N 18281158 N12KFN12kf LLC · Pass Christian, MSBuilt 1973 · S/N 21059853 N12KMFitzmaurice Productions Inc · Fawnskin, CABuilt 1977 · S/N 18265774 N12LRBalk Martin · Warren, NJBuilt 1978 · S/N 18266528 N12PFRucker Gary R · Kingman, AZBuilt 1977 · S/N 21062401 N12PWOhio State University College Of Engineering · Columbus, OHBuilt 1972 · S/N 21059796

Back to AD 84-10-01 R1