Skip to content

Registered aircraft · 56,580

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N2TPHanchett James R · Cheboygan, MIBuilt 1963 · S/N 17250269 N2WSeldom Seen Aviation Northwest Inc · Stevensville, MTS/N 185-02982 N2WFMaine Dept Of Agriculture Conservation & Forestry · Old Town, MEBuilt 1975 · S/N U20602849 N2XCMiller Virgil J · Milton Freewater, ORS/N 17266833 N2XNDudebuddy Aviation LLC · Kalispell, MTBuilt 1980 · S/N 18267615 N2YROverland Missions Inc · Cocoa, FLS/N U20601737 N2ZDMelin Lynn Glenn · Scottsdale, AZBuilt 1974 · S/N 18262867 N300Texas Sky Masters Inc DBA · Dallas, TXBuilt 1976 · S/N P3370236 N3000QFlying H Enterprises · Santa Fe, NMBuilt 1967 · S/N 18258000 N3000TN3000t LLC · Townsend, GABuilt 1967 · S/N 337-0600 N3000UMerrell Warren W · Idalou, TXBuilt 1963 · S/N 17250600 N3000YChesebro Ben D · Tucson, AZBuilt 1962 · S/N 18254000 N30013Patton Mark E · Dryden, NYBuilt 1968 · S/N 17701023 N30014Tri-State Aviators LLC · Ironton, OHBuilt 1968 · S/N 17701024 N30017Landon Kasiri · Lancaster, CABuilt 1968 · S/N 17701025 N3001UPrairie Flyers · Rocky Ford, COBuilt 1963 · S/N 17250601 N3002QJaeger Christopher E · Normandy Park, WABuilt 1967 · S/N 18258002 N3002YGiefer Brett T · Nicollet, MNBuilt 1962 · S/N 18254002 N30033Mission Aviation Training Academy · Arlington, WABuilt 1968 · S/N 17701036 N30038Stockyard LLC · Wilmington, DEBuilt 1973 · S/N 21059879 N3003ETuskegee Airmen National Historical Museum · Detroit, MIBuilt 1978 · S/N 17271400 N3003FHassinger Farms LLC · Cove, ORBuilt 1966 · S/N 18257103 N3003JCoastal Valley Aviation · Santa Maria, CABuilt 1965 · S/N 15061103 N3003XAero Flyers LLC · Stephenson, VABuilt 1966 · S/N 15064403 N30040Schaller Neil J · New Athens, ILBuilt 1968 · S/N 17701043 N30043Singer Mark D · Stafford, VABuilt 1968 · S/N 17701045 N30044Air Data Solutions LLC · Natchitoches, LABuilt 1968 · S/N 17701046 N3004ABaan Richard J · Live Oak, FLBuilt 1953 · S/N 25648 N3004FN3004f LLC · Cranberry Township, PABuilt 1966 · S/N 18257104 N3005AMarquiss Merritt L · Gillette, WYBuilt 1953 · S/N 25649 N3005FE & E Jones Farms LLC · Munford, ALBuilt 1966 · S/N 18257105 N3005SSpennato Peter Jr · Rolling Hills, CABuilt 1967 · S/N 15066905 N3005XOso Air LLC · Missoula, MTBuilt 1966 · S/N 15064405 N30064Avarix Inc · Cool, CAS/N 17701053 N3006ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1953 · S/N 25650 N3006QHarrington Michael L · Twin Falls, IDS/N 18258006 N3006SGrice Warren A · Marshall, ARBuilt 1967 · S/N 15066906 N3006XRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1966 · S/N 15064406 N3006YWissner Martin L · Carpenter, WYBuilt 1963 · S/N 18255082 N3007AFly8ma LLC · Big Lake, AKBuilt 1953 · S/N 25651 N3007FTroelstra Frederick D · Queensbury, NYBuilt 1966 · S/N 18257107 N3007XKelley Keith B · Forney, TXBuilt 1966 · S/N 15064407 N3008EShore Gerald E · Inez, TXBuilt 1978 · S/N 17271401 N3008XAdams Harold L · Beaver, OHBuilt 1966 · S/N 15064408 N3008YWidmier Kolby J · Price, UTBuilt 1962 · S/N 18254008 N30096Sirek David G · Fritch, TXBuilt 1968 · S/N 17701057 N30098Humbert Randy M · Tumtum, WAS/N 17701059 N3009ARoberts Stephen · Camas, WABuilt 1953 · S/N 25653 N3009SRegistration Pending · Arlington, TXRegistration pendingBuilt 1967 · S/N 15066909 N3009XWarren Jeremy I · Horse Cave, KYBuilt 1966 · S/N 15064409

Back to AD 79-10-14 R1