Registered aircraft · 10,537

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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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.

N3133PLumley John J · Delray Beach, FLFirst renewal noticeBuilt 1957 · S/N 23-1057 N3134LTrax Eric E · Vero Beach, FLBuilt 1965 · S/N 310J0134 N3134PSchmidt Casey D · Cedar Rapids, IAS/N 23-1059 N3135LTempelhof Aviation · Las Vegas, NVBuilt 1965 · S/N 310J0135 N313ASStephen Air LLC · Woodsfield, OHBuilt 1980 · S/N 34-8070331 N313JHJam Three LLC · St George, UTBuilt 1974 · S/N 310Q1011 N313RWSarp Rentals LLC · Loudon, TNBuilt 1969 · S/N 414-0010 N3144PEurohaus LLC · Phoenix, AZBuilt 1957 · S/N 23-1075 N314DBrantley Hugh Lawton · Hazlehurst, GABuilt 1965 · S/N 320C-0067 N314DFAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1975 · S/N 34-7570285 N314GRVice One LLC · Las Vegas, NVS/N 340A1028 N314K314-K Associates LLC · Stratford, CTBuilt 1983 · S/N 31-8352025 N314KBMatthews Grover C · Hardinsburg, KYBuilt 1958 · S/N 23-1391 N314MGSummit Aviation LLC · Las Vegas, NVS/N 340A0284 N3150LS & S Aircraft Inc · El Dorado, ARBuilt 1965 · S/N 310J0150 N31530Wheeler Auctions & Real Estate LLC · Paris, MOBuilt 1978 · S/N 34-7870238 N3153LMiller James R · Parowan, UTBuilt 1965 · S/N 310J0153 N3154LOnisko Aidan C · Williams, CAS/N 310J0086 N31595Highlander Air LLC · Kalispell, MTBuilt 1978 · S/N 34-7870243 N315AKAlsworth Glen R Sr · Port Alsworth, AKBuilt 1978 · S/N 317852083 N315BPKing Logistics LLC · Ridgeland, MSBuilt 1979 · S/N TC-2230 N315EBBaas Holdings LLC · Lewes, DEBuilt 1978 · S/N 34-7870357 N315GVancleve Cole · Cotulla, TXBuilt 1965 · S/N TC-907 N315MDuckwing LLC · Reno, NVS/N 421B0107 N315NYPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7754031 N3161PEga Aero Specialty Services LLC · Beaufort, SCBuilt 1957 · S/N 23-1093 N31629Wolff Aviation LLC · Cumberland, MDS/N 34-7870246 N3162LG&M Aircraft · Wheat Ridge, COBuilt 1965 · S/N 310J0162 N3165LToll Harry V · Tucson, AZBuilt 1965 · S/N 310J0165 N3165PNordstrand Steven D · Oak Harbor, WABuilt 1957 · S/N 23-1097 N31662Star Air Service LLC · Jacksonville, FLS/N 34-7870249 N3169LPhillips James A · Burlington, WIFirst renewal noticeBuilt 1965 · S/N 310J0169 N316AKKuspuk School District · Aniak, AKS/N 318152118 N316DFThacker Orbie A · Wellington, ALFirst renewal noticeBuilt 1997 · S/N TH-1817 N316HABidzy To Hot Aana Corp · Dillingham, AKS/N 31-7652133 N316PABird Acquisition LLC · Phoenix, AZBuilt 2002 · S/N 4496125 N316RALeading Edge Flight Services Inc · Hampshire, ILBuilt 1974 · S/N 310Q1100 N316WCEagle Aeronautics LLC · Chicago, ILS/N 421C1047 N3174BBrydon Robert J · Lago Vista, TXBuilt 1994 · S/N TH-1724 N3174TChartwell Services Inc · Wilmington, DEBuilt 1998 · S/N TH-1874 N3175WKristoffer & Co · Jacksonville, FLBuilt 1973 · S/N TC-1614 N3177WCraniatwo LLC · Peoria, ILBuilt 2000 · S/N TH-1967 N3178AMarine Aviation LLC · New Bedford, MABuilt 1970 · S/N TH-3 N31799Kaschmitter Enterprises Inc · Grangeville, IDBuilt 1978 · S/N 34-7870266 N3179LPeregrine Aviation LLC · Oro Valley, AZBuilt 1965 · S/N 310J0179 N317AKSafeco Leasing LLC · Port Alsworth, AKS/N 31-7752145 N317HABauer Aviation LLC · Saint Germain, WIBuilt 1977 · S/N 31-7812043 N317LAviation Adventures And Publications Inc · Wilmington, DEBuilt 1961 · S/N 310-0126 N317MZValiair Lc Trustee · Casper, WYBuilt 1981 · S/N 414A-0633 N317PASkywest Leasing Inc · St George, UTS/N 4496133

Back to AD 2004-25-16 R1