OpenAirDocs.org
AD 2004-25-16 R1

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
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.

N25698Tupelo Aeronautics Inc · Tupelo, MSS/N TC-1603N2569SMatanane Roke C · Barrigada, GUBuilt 1968 · S/N 337-0869N256AAAlf Ix LLC · Chicago, ILBuilt 2019 · S/N 4496476N256ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496067N256JD Gordon Aviation Inc · La Jolla, CABuilt 1978 · S/N ME-107N25734Gardner Aviation LLC · Hot Springs, ARBuilt 1973 · S/N TH-390N2575SDulin Morgan L · Midland, TXBuilt 1968 · S/N 337-0875N2577SHurt Randall L · Smithville, TNBuilt 1968 · S/N 337-0877N2578UBond Air Cargo LLC · Doral, FLS/N 34-7970453N257ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496071N257JDAntonini Vittorio · New York, NYBuilt 1970 · S/N 310Q-0071N257SHDodson International Parts Inc · Rantoul, KSS/N 31-8052121N2582ZChandler Air Service Inc · Chandler, AZBuilt 1980 · S/N 27-8154004N2587SFlying Tater LLC · Toms River, NJBuilt 1968 · S/N 337-0887N258BBGhanimian Zaven · Encino, CABuilt 1977 · S/N TH-892N258DTwin Engine Express LLC · Lewes, DEBuilt 1995 · S/N TH-1740N258ESanogo Fousseni · Houston, TXBuilt 1964 · S/N TC-701N258MTK5 Aviation LLC · Lewes, DES/N TH-244N258NCFidelis Flight Group Inc · Elm Springs, ARBuilt 1978 · S/N TH899N258PChamberlin Charles · Winchester, TNBuilt 1981 · S/N TC-2414N258RMNighthawk N8231g LLC · Pompano Beach, FLS/N 44-8107029N258RPInternational Air Services Inc Trustee · Carson City, NVBuilt 1994 · S/N TH-1737N258TNKrause Jason · Glendale, AZBuilt 1988 · S/N TH-1539N2593ZGuillen Gregorio J · Phillipsburg, NJS/N 27-8154007N2598NRed Tail Scholarship Foundation · Tuskegee, ALBuilt 1984 · S/N 31P-8414050N259ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496080N25ADPaxton Homes LLC · Killeen, TXBuilt 1983 · S/N 348333001N25BMaine Instrument Flight · Augusta, MES/N ME-49N25EBLeisurecorp Inc · Anchorage, AKBuilt 1976 · S/N 340A0043N25EWBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 310K0063N25FAFly Rite Aviation LLC · Fort Myers, FLBuilt 1973 · S/N 34-7450047N25FERound Trip Lc · Elkhart, KSS/N 421-0055N25FTPacific Fleet Aviation LLC · Rochester, NYBuilt 1976 · S/N 27-7754038N25JFBuckingham James M · Palmer, AKBuilt 1968 · S/N 27-3903N25LPBer Aviation Inc · Saratoga, CABuilt 1973 · S/N 310Q0748N25PDKnew Man Group LLC · New Orleans, LABuilt 1994 · S/N 3448050N25PKPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7754105N25PRInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 30-1511N25RFMlf Aviation LLC · Douglasville, GABuilt 1973 · S/N 340-0307N25RMSky Travel LLC · Clayton, MOS/N TJ-459N25TAJms Properties Inc · Hudsonville, MIBuilt 1982 · S/N 340A1538N2604SGillespie Dan L · Discovery Bay, CABuilt 1968 · S/N 337-0904N2604ZBurgan Grover W · Jacksonville, FLBuilt 1981 · S/N 27-8154012N2608ZKaufield John E · Garden Prairie, ILBuilt 1981 · S/N 27-8154015N260ARDeep South Flying Services LLC · Albany, GABuilt 1983 · S/N TJ436N260FLFox Leasing Group LLC · Hollywood, FLBuilt 2023 · S/N 4496563N260RAUpward Aviation LLC · Tulsa, OKBuilt 1980 · S/N 421C1004N260STPitts S2b LLC · Salinas, CABuilt 1981 · S/N 34-8133047N2610Avionicos Corp · Nokomis, FLBuilt 1977 · S/N 34-7770428N2610SGordon Daryl B · Bellevue, WABuilt 1968 · S/N 337-0910
Back to AD 2004-25-16 R1