Skip to content

Registered aircraft · 20,483

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.

N415LEStadelman Edwin F · East Falmouth, MABuilt 1999 · S/N 20608042 N415RCAvco Patrol LLC · Lyndon, KSBuilt 1998 · S/N 18280302 N4160CNewman Holdings LLC · Dallas, TXBuilt 1978 · S/N R18200332 N4164COld Blue Solutions LLC · Harvest, ALS/N R18200333 N4166CBas Part Sales LLC · Greeley, COBuilt 1978 · S/N R18200334 N4169YVanderhoof Chad T · Elk, WAS/N 185-0369 N416CSTextron Aviation Inc · Wichita, KSBuilt 2016 · S/N 18282416 N4175CSalciccioli Christopher · Joshua Tree, CABuilt 1978 · S/N R18200336 N41782Kansas Soaring Assoc Inc · Wichita, KSBuilt 1955 · S/N 613 N417CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283025 N417DDSc Flyers Inc · Wilmington, DEBuilt 2002 · S/N 18281169 N417ESPearce James R · Germantown, TNBuilt 1997 · S/N 18280082 N417JMTulsa Aviation Partners LLC · Tulsa, OKBuilt 2000 · S/N 18280837 N417LFRussell Tommy Edward · Kingsport, TNBuilt 1976 · S/N 18264714 N417RGWagner Aviation LLC · Laura, OHBuilt 1998 · S/N 18280231 N4183CLockhart Curtis M · Bay Village, OHBuilt 1978 · S/N R18200338 N4183NEndeavour Flight Training Inc · Miami, FLBuilt 1998 · S/N 18280150 N4188YSandberg Steven R · Malta, ILBuilt 1962 · S/N 185-0388 N418DKKnies Aviation Inc · Huntsville, ALBuilt 1964 · S/N 21058435 N418DMMria LLC · Phoenix, AZBuilt 2015 · S/N 18282418 N418MBRed Baron LLC · Dickinson, NDBuilt 1977 · S/N 18266154 N418PRHunnicutt Gerald E · Hendersonville, NCBuilt 1978 · S/N R18200475 N418SASummit Aviation Inc · Middletown, DEBuilt 1979 · S/N 18267433 N418WRBeegles Aircraft Service LLC · Greeley, COBuilt 1997 · S/N 18280034 N4193YVan Dorpe Ross · Saint Charles, ILBuilt 1998 · S/N 18280359 N4194QJacques Jerry J · Iliamna, AKS/N U2061359 N4195EHusky Central LLC · Hugo, OKBuilt 1998 · S/N 18280363 N4195RPlain LLC · Traverse City, MIBuilt 1998 · S/N 18280364 N4196DCub Club Incdba · Fort Myers, FLBuilt 1999 · S/N 18280461 N4196GProuse Craig H · Groveland, CABuilt 1998 · S/N 18280367 N4197QSumner Properties LLC · Somersworth, NHBuilt 1998 · S/N 18280370 N4197XBarr Air Patrol LLC · Mesquite, TXBuilt 1999 · S/N 18280449 N4199TEnga James Craig · Madison, SDBuilt 1998 · S/N 18280372 N419BEVolar La Vida LLC · Kalispell, MTBuilt 1968 · S/N 18259409 N419CSGarza Richard · Monterey, CABuilt 2016 · S/N 18282419 N419JARaw Aviation LLC · Wichita, KSBuilt 2007 · S/N 18281885 N41ARobertson Roy E · Marion, IABuilt 1978 · S/N 21062798 N41BXWilliams Paul E · Kendallville, INBuilt 1981 · S/N 18053197 N41CEWhats Up Doc Aviation LLC · Alexander, ARBuilt 1978 · S/N 21062872 N41CHLaperle Brian D · Colebrook, NHBuilt 1956 · S/N 32319 N41DLLdair Inc · Roanoke, VABuilt 2002 · S/N 18281142 N41GCAviation Of North Florida LLC · Jacksonville, FLBuilt 1956 · S/N 33612 N41GVRbs Inc · Wht Sphr Spgs, WVBuilt 1977 · S/N 18265837 N41JCKiddink LLC · Wilmington, DES/N 18267036 N41MCGarner John B · Newark, DEBuilt 1984 · S/N 18268379 N41MQParsons Douglas L · Carrollton, OHBuilt 1978 · S/N 18266506 N41MTX2nsat Inc · Petaluma, CABuilt 1977 · S/N 18265725 N41YYSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 21063653 N42002Kuntz Jonathan W · Yorktown, VABuilt 1968 · S/N 18258801 N42004Haskell Airport Inc · Coweta, OKBuilt 1999 · S/N 18280446

Back to AD 84-10-01 R1