Skip to content

Registered aircraft · 930

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:76-14-07-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:76-14-07-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:76-14-07-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:76-14-07-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:76-14-07-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:76-14-07-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.

N5986FBingham Darold R · Idaho Falls, IDBuilt 1968 · S/N 21058986 N5996FL M W Leasing · Midlothian, TXBuilt 1968 · S/N 21058996 N5998FMedic Choppers LLC · Springdale, ARS/N 21058998 N6100BParas Mark J · Camas, WAS/N 21058068 N6100FTri Rotor Spray & Chemical · Ulysses, KSBuilt 1968 · S/N 21059000 N6103RAta Auto Service Inc · Wilmington, NCBuilt 1965 · S/N T210-0003 N6105FShaw Christopher S · Porterville, CABuilt 1968 · S/N 21059005 N6109RBas Part Sales LLC · Greeley, COBuilt 1965 · S/N T210-0009 N6110FKilmer Scott D · Fort Pierce, FLBuilt 1968 · S/N 21059010 N6112FPcb Inc · Paradise, CAS/N 21059012 N6114RJstream Lc · Sheridan, WYS/N T210-0014 N6116RAirxn LLC · Williams, AZBuilt 1965 · S/N T210-0016 N6117FBahl Lawrence S · Lottsburg, VABuilt 1968 · S/N 21059017 N6121FT & B Aero Enterprises Inc · Jacksonville, FLS/N 21059021 N6125FParker Richard A · West Chicago, ILBuilt 1968 · S/N 21059025 N6126FCarson John D · Garber, OKBuilt 1968 · S/N 21059026 N6126RKelley Kal · Colville, WAS/N T210-0026 N6127FSmith Phillip · Osprey, FLBuilt 1968 · S/N 21059027 N6127RPhillips Bill · Galt, CABuilt 1965 · S/N T210-0027 N6128ROhop Robert D · Jones, OKBuilt 1965 · S/N T210-0028 N6129RIncline Engineering And Consulting LLC · Ovalo, TXBuilt 1965 · S/N T210-0029 N6130FBas Part Sales LLC · Greeley, COBuilt 1968 · S/N 21059030 N6130RHarris Phillip S · Greenwood Village, COS/N T210-0030 N6131FLundell Brandon M · Lyons, COBuilt 1968 · S/N 21059031 N6131RAir LLC · Salem, ORS/N T210-0031 N6137FWingland Inc · Los Angeles, CABuilt 1968 · S/N 21059037 N6138FSchlegelmilch Scott A · Elkhorn, NEBuilt 1968 · S/N 21059038 N6147FHenry Charles C · Portland, TNBuilt 1968 · S/N 21059047 N6148FWorsham Eric S · La Porte, TXS/N 21059048 N6151RPath Barney H DBA · Claremont, CABuilt 1965 · S/N T210-0051 N6152FFisher Wayne G Trustee · Gainesville, FLBuilt 1968 · S/N 21059052 N6155RPlane + Simple LLC · Salt Lake City, UTBuilt 1965 · S/N T210-0055 N6158RMahany John C · Yucca Valley, CABuilt 1965 · S/N T210-0058 N6161FBeach Bums Air LLC · Martin, GABuilt 1968 · S/N 21059061 N6162RSmjd LLC · Penrose, COBuilt 1965 · S/N T210-0062 N6165FMainely Lobsters · Gulf Breeze, FLBuilt 1968 · S/N 21059065 N6169FWatrud Joel Carl · Waskish, MNS/N 21059069 N6170FWilkins Raymond E · Osceola, IABuilt 1968 · S/N 21059070 N6170RBrown Michael R · Huntsville, ALBuilt 1965 · S/N T210-0070 N6171FDohrenwend Mark G · Owensboro, KYBuilt 1968 · S/N 21059071 N6173FLesondank Stephen M · Bellvue, COBuilt 1968 · S/N 21059073 N6173RBeyer Livestock Auction LLC · Clovis, NMBuilt 1965 · S/N T210-0073 N6175RElinoff Neal D · Telluride, COBuilt 1965 · S/N T210-0075 N6176RJulius Kaleb · Mesa, COBuilt 1965 · S/N T210-0076 N6187FNuxoll Builders · Clarkston, WABuilt 1968 · S/N 21059087 N6188RPeterson Bruce L · Brighton, COBuilt 1966 · S/N T210-0088 N6192RAmbrosini Helicopters Inc · Fresno, CABuilt 1966 · S/N T210-0092 N6193FRheinbolt John N · Highmore, SDBuilt 1968 · S/N 21059093 N6195FRegistered aircraftBuilt 1968 · S/N 21059095 N6199FAcara Aviation LLC · Portage, MIS/N 21059099

Back to AD 76-14-07 R2