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.

N340SDRegistration Pending · Kaukauna, WIRegistration pending, canceledS/N 340A0408N340SGN340sg Leasing LLC · Sheridan, WYBuilt 1980 · S/N 340A0973N340SHHenderson Scott · Tucson, AZBuilt 1978 · S/N 340A0548N340STSchlabach Herman · Belton, TXBuilt 1978 · S/N 340A0528N340SUDm Air Ltd · Newark, OHS/N 340A0979N340SVQuetzal Aviation Corp · Washington, DCBuilt 1980 · S/N 340A1003N340TARmb Leasing Inc · Dover, DEBuilt 1979 · S/N 340A0648N340TBBerkshire Building Services Inc · South Egremont, MABuilt 1976 · S/N 340A0066N340TG340tg LLC · Elm Springs, ARS/N 340A0730N340THHinkle Anthony · Mineola, TXS/N 340A0501N340TLRegistration Pending · Henderson, NVRegistration pendingBuilt 1975 · S/N 340A0018N340TSNighthawk Flight Systems Inc · Vista, CABuilt 1980 · S/N 340A0999N340TTPrecision Aviation LLC · Costa Mesa, CABuilt 1980 · S/N 340A1034N340UGonzalez Pablo II · Sweeny, TXBuilt 1978 · S/N 340A0530N340UMSouthwest Management Group Inc · Farmington, NMBuilt 1979 · S/N 340A0698N340VAMel Hambelton Ford Inc · Wichita, KSBuilt 1979 · S/N 340A0915N340VCStc Aviation Inc · Saint Cloud, MNS/N 340A0296N340VLVanguard R&R Lease Co Inc · Dallas, TXBuilt 1984 · S/N 340A1811N340VVYouth Aviation Academy · Roseville, CABuilt 1972 · S/N 340-0087N340WPraetorian Aviation Services LLC · Alva, FLBuilt 1973 · S/N 340-0317N340WAFoshay Laird · Paso Robles, CABuilt 1972 · S/N 340-0035N340WDKnoxville Air Charter Service LLC · Strawberry Plains, TNBuilt 1974 · S/N 340-0509N340WGBartlein & Co Inc · Santa Barbara, CABuilt 1972 · S/N 340-0182N340WHN340dg LLC · Spanish Fork, UTBuilt 1974 · S/N 340-0366N340WJIntegritas Aviation LLC · Cedar Park, TXBuilt 1979 · S/N 340A0774N340WMHarco Aviation LLC · Houston, TXBuilt 1978 · S/N 340A0612N340WPNnk Holdings LLC · San Antonio, TXBuilt 1981 · S/N 340A1240N340XCPrairie Aero LLC · Baldwin City, KSBuilt 1976 · S/N 340A0098N340XPN340xp LLC · Wellington, FLS/N 340A0741N340XXTaylor Christopher A · Phoenix, AZBuilt 1979 · S/N 340A0689N340YDown The Line LLC · Newport Beach, CAS/N 340A-0404N340YCBa Air LLC · Searcy, ARBuilt 1977 · S/N 340A0375N340YPSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 340A-0990N340YZN340yz Corp Trustee · Wilmington, DEBuilt 1976 · S/N 340A0019N341Lurky Ilm LLC · Delco, NCBuilt 1981 · S/N TC-2369N3412QPoulsen Melvin J · Orem, UTS/N 320E0012N3417QGholami Amir H · Santa Rosa, CABuilt 1966 · S/N 320E0017N341ATKlodd Stephen · Granbury, TXBuilt 1978 · S/N 340A0422N341BCAbeflies LLC · Montvale, NJBuilt 1972 · S/N 340-0015N341BGAttack Jack Enterprises LLC · Wilmington, DEBuilt 1973 · S/N 340-0233N341CACovenant Air LLC · Wilmington, DEBuilt 1979 · S/N 31-7952243N341CHAce Flight Center Inc · St Thomas, VIBuilt 1980 · S/N 27-8154006N341CMBc Aviation · Perham, MNBuilt 1981 · S/N 340A1255N341HCStc Aviation Inc · Saint Cloud, MNBuilt 1979 · S/N 340A0798N341JPRed Arrow Leasing Inc · Paw Paw, MIS/N 340A0293N341MTI2i Logistics LLC · Wheeling, ILBuilt 1980 · S/N 340A0980N341RBRomeo Bravo LLC · Thompson, MOS/N 421C1112N341SCShedd Aviation LLC · Columbus, INBuilt 1984 · S/N 340A1810N341SJAga Aviation LLC · Lewes, DES/N 340A0222N341TCRegistration Pending · Wilmington, DERegistration pendingBuilt 1974 · S/N 34-7450161
Back to AD 2004-25-16 R1