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.

N732AXAnimal Hospital Of Fayetteville Pa · Fayetteville, NCS/N 21061373 N732BASparks Steve · Hamilton, OHBuilt 1976 · S/N 21061376 N732BBBishop Thomas W · Decatur, TXBuilt 1976 · S/N 21061377 N732BHSeven Eagles Aviation Lc · Gainesville, FLBuilt 1976 · S/N 21061383 N732BKJones Mark A · Johnson City, TXBuilt 1976 · S/N 21061385 N732BYMartin James Dwight · Lancaster, PABuilt 1976 · S/N 21061398 N732CBAire Flight Systems Inc · Midwest City, OKBuilt 1976 · S/N 21061400 N732CHRegistration Pending · Athens, TNRegistration pendingBuilt 1976 · S/N 21061406 N732CRGlobal Energy Werks LLC · Ely, MNBuilt 1976 · S/N 21061414 N732CXEvans Terry W · Corning, IABuilt 1976 · S/N 21061420 N732DKMckay Donald E · White City, ORBuilt 1976 · S/N 21061432 N732DLN732dl LLC · Driftwood, TXBuilt 1976 · S/N 21061433 N732DMFlying Knights LLC · Farmington, NMS/N 21061434 N732DQAcme Do It Yourself Tornado Kits LLC · Draper, UTBuilt 1976 · S/N 21061437 N732DWKowalczyk Ryan · Boise, IDBuilt 1976 · S/N 21061443 N732DZBbak Mik LLC · Ontario, ORBuilt 1976 · S/N 21061446 N732ECPompa Oliver · Tucson, AZBuilt 1976 · S/N 21061448 N732EEK6 Flying LLC · Murtaugh, IDS/N 21061450 N732ELAndiamo Aviation LLC · Georgetown, TXBuilt 1976 · S/N 21061456 N732EPPorebski L P Jr · Odessa, FLBuilt 1976 · S/N 21061459 N732EWFiller Leslie Trustee · Emerald Hills, CABuilt 1976 · S/N 21061466 N732EXBorszich Claude C Jr · Phoenix, AZBuilt 1976 · S/N 21061467 N732EZButler Aviation Llp · Smyrna, TNBuilt 1976 · S/N 21061469 N732FCRuhsam Harry M · Saint Augustine, FLBuilt 1976 · S/N 21061472 N732FJIrf LLC · Boonton Township, NJBuilt 1976 · S/N 21061478 N732FPLancair Of Texas DBA · Snyder, TXBuilt 1976 · S/N T21061482 N732FXJanitell Brandan M · Helena, MTBuilt 1976 · S/N 21061489 N732GGMurphy Niccolai A · Poway, CABuilt 1976 · S/N 21061497 N732GHPeters Brian E · Las Vegas, NVBuilt 1976 · S/N 21061498 N732GK3jc LLC · Phoenix, AZBuilt 1976 · S/N 21061500 N732GPGulf Pop Aviation · Saint Augustine, FLS/N 21061504 N732HDMgp Investments LLC · Woods Cross, UTBuilt 1976 · S/N 21061518 N732HKAnderson Milton M · Twin Bridges, MTS/N 21061524 N732HRBowdle Ricke H · San Dimas, CABuilt 1978 · S/N U20604680 N732JFSpeed Of Light Aerospace LLC · Lompoc, CABuilt 1976 · S/N 21061543 N732JJCj Air LLC · Escondido, CABuilt 1976 · S/N 21061546 N732JMGarcia Victor C · Cameron Park, CABuilt 1978 · S/N U20604685 N732JS732js Partners Ltd · Batavia, ILBuilt 1976 · S/N 21061554 N732JTKittatinny Leasing Co Inc · Friendsville, TNBuilt 1976 · S/N 21061555 N732JWSunniland Ranch Airport LLC · Okeechobee, FLS/N 21061558 N732JZChalk 2 Inc · Apple Valley, CABuilt 1976 · S/N 21061561 N732KBTadco Equipment Inc · Laveen, AZBuilt 1976 · S/N 21061563 N732KCKing Daddy Aviation LLC · Madison, MSBuilt 1976 · S/N 21061564 N732KEMcintosh Ian K · Floydada, TXS/N 21061566 N732KLWestern Radio Services Co · Prineville, ORBuilt 1976 · S/N 21061572 N732KPB&M Aviation LLC · Montgomery, TXBuilt 1976 · S/N 21061575 N732KQPerea Rudolph A · Dayton, NVBuilt 1976 · S/N 21061576 N732LFGalante Tandy · Cave Creek, AZS/N 21061591 N732LLGaston James D · Meridianville, ALBuilt 1976 · S/N 21061596 N732LPAgile Innovations LLC · Kalispell, MTS/N 21061599

Back to AD 84-10-01 R1