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.

N36PBMarin Pacific International LLC · Apple Valley, CABuilt 1973 · S/N 31-7405128N36TAN36ta LLC · Dover, DES/N TH-2056N36WALandreth Kevin R · Ponca City, OKBuilt 1964 · S/N 30-581N370Bas Part Sales LLC · Greeley, COBuilt 1965 · S/N 27-3084N3701DN3701d LLC · Wilmington, NCBuilt 1980 · S/N TH-1187N3705JAzuma Company · Salinas, CABuilt 1980 · S/N TK-132N3707TFisher Kurt A · San Luis Obispo, CABuilt 1970 · S/N TH-110N370MDAlmost There Air LLC · Daytona Beach, FLBuilt 1972 · S/N 27-4814N370SASharp Spears LLC · Vero Beach, FLBuilt 1979 · S/N 278054005N370TBellas Business LLC · Kalispell, MTBuilt 1958 · S/N 23-1506N3711NBay Area Concrete LLC · Hayward, CABuilt 1980 · S/N ME-375N3711YAero Venture Lc · Shreveport, LABuilt 1977 · S/N TH-828N3714STwesme Scott · Lake Mills, WIBuilt 1981 · S/N TC-2356N3715BBombers And Barons LLC · Haughton, LABuilt 1980 · S/N TH-1200N3715CHangar Ten LLC · Westfield Center, OHS/N TC-2391N37181Jrs Aviation LLC · Falls City, NEBuilt 1980 · S/N 414A0511N371AKSweeney James J III · Glenwood Springs, COBuilt 1979 · S/N ME-157N371AMPreuss Andrew J · North Charleston, SCBuilt 1968 · S/N 27-4005N371DSCl Finney Aviation LLC · Benton, KSBuilt 1955 · S/N 23-153N371MCSale Reported · Palm City, FLSale reportedS/N 31-7405409N371STvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 340A0300N371SBN333bc LLC · Franktown, COS/N 421C1072N371WAAkro Attitudes Inc · Lighthouse Point, FLBuilt 1976 · S/N 31-7612042N3724BFlorida Flyers Flight Academy Inc · Saint Augustine, FLBuilt 1980 · S/N ME349N3724HAviation Capital Management LLC · San Jose, CABuilt 1982 · S/N ME-350N37285Java Air LLC · Visalia, CABuilt 1979 · S/N 340A0953N3728GDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N ME-357N372JCompass Rose Services Inc · Powell Butte, ORBuilt 1966 · S/N 320D0114N372NMShelter Michael R · Sandy Lake, PABuilt 1970 · S/N 310Q0115N373Clayland Walter · San Rafael, CABuilt 1966 · S/N 30-1374N37302Elrod Jason A · Seattle, WABuilt 1977 · S/N 340A0334N37306Frescomar USA LLC · Miami, FLS/N 340A0336N37315Atlantic Coast Contractors Inc · Denver, NCBuilt 1977 · S/N 340A0341N3733DSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1980 · S/N ME-362N3733GPilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1980 · S/N ME-364N37343Bearings & Belts LLC · Carlsbad, NMBuilt 1977 · S/N 340A0358N37356Congregation Rosh Hagivah Inc · Waterbury, CTBuilt 1977 · S/N 340A0364N37360Tkn Holdings LLC · Pima, AZBuilt 1978 · S/N 340A0402N37376Trans Western Leasing LLC · Sheridan, WYBuilt 1977 · S/N 340A0374N3737UAirria Holdings LLC · BerlinBuilt 1980 · S/N ME-379N3739BClipper Air LLC · Cresson, TXBuilt 1980 · S/N TH-1198N3739QN3739q LLC · Colleyville, TXFirst renewal noticeBuilt 1982 · S/N ME-378N373DHigh Flight Baron LLC · Holland, MIBuilt 1980 · S/N TJ-299N373JCVon Allman Chris D · Dos Palos, CABuilt 1962 · S/N 310G0137N37404Bear Giant LLC · Eden Prairie, MNBuilt 1977 · S/N 421C0339N37417Registered aircraftS/N 421C0344N37424Flight Development LLC · Wichita, KSS/N 421C0658N3744UCristiani Sandra Elizabeth · Miami, FLBuilt 1981 · S/N 318312006N3746PSale Reported · Fort Lauderdale, FLSale reported, canceledS/N 31-7752095N37475N37475 Management LLC · Las Vegas, NVBuilt 1977 · S/N 421C0412
Back to AD 2004-25-16 R1