Skip to content

Registered aircraft · 26,232

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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N7713EFitzgerald Keith M · Coopersburg, PABuilt 1959 · S/N 17513 N7713THatton Daniel R · Portland, ORS/N 47313 N7713UDavisson Paul V · Jupiter, FLBuilt 1964 · S/N 17251713 N77140Bettendorf Elizabeth J · Salem, ORBuilt 1946 · S/N 11598 N77143Aukeman Mark C · Georgetown, MEBuilt 1946 · S/N 11601 N77147Dickson Aaron M · Arkadelphia, ARBuilt 1946 · S/N 11609 N77148Bruffy Matt · Boerne, TXBuilt 1946 · S/N 11610 N7714FRegistration Pending · Oxford, MIRegistration pendingS/N 15063814 N7714UKimbrell Quentin · Cape Girardeau, MOS/N 17251714 N7714XLenhardt Edward J · Green Lane, PABuilt 1961 · S/N 17248214 N77153Johnson Lawrence F · Anchorage, AKBuilt 1946 · S/N 11615 N77159Hamill Zachary A · Gridley, CABuilt 1946 · S/N 11621 N7715UFenton Dale R · New Bern, NCBuilt 1964 · S/N 17251715 N77161Hull Terri L · Weirsdale, FLBuilt 1946 · S/N 11623 N77163Knefley Michael J · Ulysses, PABuilt 1946 · S/N 11625 N77165Mohar Fred B Jr · Turner, MTBuilt 1946 · S/N 11627 N77169Colborn William C · Holly Springs, NCBuilt 1946 · S/N 11631 N7716UOpportune Entity LLC · Sanger, TXBuilt 1964 · S/N 17251716 N77173Ackerman Garry A · Plano, TXBuilt 1946 · S/N 11635 N77174Merrell Blaine W · Bainbridge, INBuilt 1946 · S/N 11636 N7717AMcclelland Jacob D · Fairfield, CABuilt 1964 · S/N 15060886 N7717TGully Samuel Lee · Noxapater, MSBuilt 1960 · S/N 47317 N7717UGreen Castle Aero Club Ltd · Oxford, IABuilt 1964 · S/N 17251717 N7718EHeuser Timothy J · Cottage Grove, ORS/N 17518 N7718FAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1966 · S/N 15063818 N77193Hospodar Robert P · Georgetown, PAS/N 11655 N77194Woosley Kenneth D · Rumsey, KYBuilt 1946 · S/N 11656 N77196Mccann Michael · Springfield, ORBuilt 1946 · S/N 11658 N77197Averbukh Anthony · Roswell, GAS/N 11659 N7719EOlson Ben A · Gig Harbor, WAS/N 17519 N7719TRushton George Emery · Clinton, MIS/N 47319 N77202Ostmeyer Mark G · Colby, KSBuilt 1946 · S/N 11664 N77207Devin R Wiseth · Fargo, NDBuilt 1946 · S/N 11669 N77209Decker Thomas V · Deridder, LABuilt 1946 · S/N 11671 N7720EAircraft Systems Group Inc · Odessa, FLBuilt 1959 · S/N 17520 N7720XJeter Thomas L · South Padre Island, TXBuilt 1960 · S/N 17248220 N77210Gomez Oscar · El Mirage, AZS/N 11672 N77211Rigsby Robert A · Burien, WABuilt 1946 · S/N 11673 N77212Hinson Stanley J Trustee · Grapevine, TXBuilt 1946 · S/N 11674 N77218Fuhrman Ronald A · Fargo, NDS/N 11680 N77219Creglow Jacob A · Soldotna, AKBuilt 1946 · S/N 11681 N7721TBourdon Alain · West Springfield, MABuilt 1960 · S/N 47321 N77220Registration Pending · Howell, MIRegistration pendingBuilt 1946 · S/N 11682 N77221Heiter Samuel L · South Bend, INBuilt 1946 · S/N 11683 N77224Baas Casey G · Oakland, FLBuilt 1946 · S/N 11686 N7722TPfc Aviation Repair Inc · Wallingford, CTS/N 47322 N7722UBeebout Shawn C · Milroy, MNBuilt 1964 · S/N 17251722 N7722XLeasure Everett D · Joliet, ILBuilt 1960 · S/N 17248222 N77230Fraser Steven · Sparks, NVBuilt 1946 · S/N 11692 N77234Vance Donn D · Monterey, TNBuilt 1946 · S/N 11696

Back to AD 94-05-05 R1