Skip to content

Registered aircraft · 20,481

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.

N761HJAmerican Aircraft Sales LLC · Lincolnshire, ILS/N 21062267 N761HNA-1 American Fence Inc · Orange, TXBuilt 1977 · S/N 21062271 N761HSLassetair LLC · Glen Ellen, CABuilt 1977 · S/N 21062275 N761HTWieckowski Peter · Boxford, MABuilt 1977 · S/N 21062276 N761HVResultant Aviation LLC · Orlando, FLBuilt 1977 · S/N 21062278 N761JCBartels Charles W · Okeechobee, FLS/N 21062285 N761JDRj Aviation LLC · Byhalia, MSBuilt 1977 · S/N 21062286 N761JK926-928 Newton LLC · Denver, COS/N 21062292 N761JMFour Star Ranch Inc · Randlett, UTS/N 21062294 N761KBOne Kilo Bravo · Renton, WABuilt 1977 · S/N 21062307 N761KEDownstown Airport Inc · Vineland, NJBuilt 1977 · S/N 21062310 N761KLBranson William E · Stokesdale, NCBuilt 1977 · S/N 21062316 N761KVDiamond X Aviation LLC · Johnson City, TXBuilt 1977 · S/N 21062325 N761LBDiamond 210 LLC · Dover, DEBuilt 1977 · S/N 21062331 N761LGTrinkle Aviation LLC · Kingsburg, CAS/N 21062336 N761LMDyer J Scott · Pleasantville, NYBuilt 1977 · S/N 21062341 N761LQFlying Pharaohs LLC · Fredericksburg, VABuilt 1977 · S/N 21062344 N761LUStowell Robert W · La Porte, INBuilt 1977 · S/N 21062348 N761LYHigh Flying Texans LLC · Arlington, TXS/N 21062352 N761MBGump Timothy K · Dalton Gardens, IDBuilt 1977 · S/N 21062354 N761MERoseburg Skyways LLC · Livermore, CAS/N 21062357 N761MJFritz Mark Andrew · Williamson, GABuilt 1977 · S/N 21062361 N761MSHarvey Scott · Hereford, AZBuilt 1977 · S/N 21062369 N761NTStroud Mark W · Durango, COBuilt 1977 · S/N 21062393 N761PJGateway Flying Club Inc · Blaine, MNBuilt 1976 · S/N 18264787 N761PPSoheily Holdings LLC · Austin, TXBuilt 1977 · S/N 21062412 N761PRBluff City Bell LLC · Caldwell, IDBuilt 1977 · S/N 21062414 N761PVKomen Mark R · Seattle, WABuilt 1977 · S/N 21062418 N761QAErnst Gary W · Emerald Hills, CABuilt 1977 · S/N 21062423 N761QVNavratil Philip R · Houston, TXBuilt 1977 · S/N 21062442 N761QXAerial Art Photography · Altadena, CABuilt 1978 · S/N 21062444 N761QYYardbird Corp · Nevada, IABuilt 1977 · S/N 21062445 N761RCClannalu Air LLC · Midland, TXBuilt 1978 · S/N 21062449 N761RDRobinson John · Farmington, NMBuilt 1978 · S/N 21062450 N761RESecrest Steven J · Roosevelt, UTBuilt 1978 · S/N 21062451 N761RGBas Part Sales LLC · Greeley, COS/N 21062453 N761RLCampbell Gordon S · Concord, CABuilt 1978 · S/N 21062457 N761SBBracl Holdings LLC · Tonganoxie, KSBuilt 1978 · S/N 21062471 N761SFParamount Enterprises Inc · Goldsboro, NCBuilt 1978 · S/N 21062475 N761SGThurmond Clark · Georgetown, TXBuilt 1978 · S/N 21062476 N761SHJs Flying Services LLC · Reno, NVBuilt 1978 · S/N 21062477 N761SPTwin City Cloud 7 Inc · Eden Prairie, MNBuilt 1978 · S/N 21062483 N761STBode Aviation Inc · Albuquerque, NMBuilt 1978 · S/N 21062487 N761SVVogt Richard L · Panama City, FLBuilt 1978 · S/N 21062489 N761TCMichigan Scientific Corp · Milford, MIBuilt 1978 · S/N 21062496 N761TEDraegerweb Aviation LLC · Linden, MIBuilt 1978 · S/N 21062498 N761THBlack Forest Wings LLC · Noblesville, INBuilt 1978 · S/N 21062501 N761TKRichards And Richards · Nucla, COBuilt 1978 · S/N 21062503 N761TLOmni International Services Inc · Reno, NVBuilt 1978 · S/N 21062504 N761TMHwbec761 LLC · Los Ranchos, NMBuilt 1978 · S/N 21062505

Back to AD 84-10-01 R1