Skip to content

Registered aircraft · 20,483

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.

N3459SStg LLC · Mountain Green, UTBuilt 1965 · S/N 18255859 N3459UWalker Cody · Jacksboro, TXBuilt 1963 · S/N 18254859 N3459YPepper William G · Fayette, MES/N 18051959 N345ALItm Aircraft LLC · Charleston, SCBuilt 1974 · S/N 20700262 N345BBBaas Brian J Trustee · Cambridge, MNBuilt 1977 · S/N 18503301 N345TJOpa Flys LLC · Magnolia, TXBuilt 2004 · S/N 18281469 N3460FCut And Snip Flyers LLC · South Weber, UTBuilt 1966 · S/N 18257460 N3460LFaulkner Jeannine P · Bethel, AKBuilt 1966 · S/N U206-0760 N3460YLeng Jeffrey E · Buckley, WABuilt 1968 · S/N 18051960 N3461SBoyle Gene J · Moab, UTBuilt 1964 · S/N 18255861 N3462FBehrendt Matthew D · Winsted, CTBuilt 1966 · S/N 18257462 N3462LFuss Douglas A · Fort Worth, TXBuilt 1966 · S/N U206-0762 N3462VSiefring Sean E · Collierville, TNBuilt 1948 · S/N 7187 N3463FLee Paula S · Sandpoint, IDBuilt 1966 · S/N 18257463 N3463LLrh Equipment LLC · Pendleton, ORBuilt 1966 · S/N U206-0763 N3463UYancey Cameron L · Anchorage, AKBuilt 1963 · S/N 18254863 N3464FBowsman Barry K · Dowagiac, MIBuilt 1966 · S/N 18257464 N3464LMolinaro Peter · Mendota Heights, MNBuilt 1966 · S/N U206-0764 N3464UEvergreen Holdings LLC · Missoula, MTS/N 18254864 N3465SWalker Kathleen L · Hartline, WABuilt 1964 · S/N 18255865 N3465VLiebfried Andrew · Lunenburg, MABuilt 1948 · S/N 7162 N3466FAgri-Tech Aviation Inc · Indianola, IABuilt 1966 · S/N 18257466 N3466SFoster Garry R · Advance, NCBuilt 1964 · S/N 18255866 N3467FHappy Trails Flight Training & Charters LLC · Helena, MTBuilt 1966 · S/N 18257467 N3467YPeninsula Aero Technology Inc · Kenai, AKBuilt 1968 · S/N 18051967 N3468FLefevre Development Co LLC · Jackson, TNBuilt 1966 · S/N 18257468 N3468YHughes Michael F · Fritz Creek, AKBuilt 1968 · S/N 18051968 N3469SStory Jerry L · Webster, FLBuilt 1964 · S/N 18255869 N3469UAndrews Nathan S · Graham, WABuilt 1963 · S/N 18254869 N346CBKombi Brazil Inc · Fort Lauderdale, FLS/N 21060712 N346RNSchroll Charles E · Tucson, AZBuilt 1969 · S/N P206-0567 N3470UThird Loop Partners · Paso Robles, CABuilt 1963 · S/N 18254870 N3471FDel Norte Flying LLC · Del Norte, COBuilt 1966 · S/N 18257471 N3471SClint Woodword Construction LLC · Prineville, ORBuilt 1964 · S/N 18255871 N3472FMiller Robert F · Locust Grove, GAS/N 18257472 N3473CKubecka Donald P · Seminole, TXS/N 18051760 N3473FBoone Bruce L · Woodland, CAS/N 18257473 N3473RBrooks Gregory Keith · Green Cove Springs, FLBuilt 1967 · S/N 18258773 N3474VWestern North Carolina Air Museum · Hendersonville, NCBuilt 1948 · S/N 7174 N3474YHanson Dan B Jr · Lusk, WYS/N 18051974 N3475FSanguinetti Mark · Winnsboro, LAS/N 18257475 N3475RMccullough Hugh J · Glennville, GABuilt 1968 · S/N 18258775 N3475SSmith Reine K IV · Lockhart, TXBuilt 1965 · S/N 18255875 N3475YAbidance Inc · Winthrop, WAS/N 18051975 N3476FDickens Charles L · Panama City Beach, FLS/N 18257476 N3476RTibbs Properties LLC · Franklin, LABuilt 1968 · S/N 18258776 N3476UNelson Robert D · Anchorage, AKBuilt 1963 · S/N 18254876 N3477FFlying T LLC · Albuquerque, NMBuilt 1966 · S/N 18257477 N3477SN3477s Inc · Dalton Gardens, IDS/N 18255877 N3479RM S Davidson Enterpries Pc · Laurel, DEBuilt 1968 · S/N 18258779

Back to AD 84-10-01 R1