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.

N83MGWatkins Jon Trustee · Florence, ORBuilt 1981 · S/N 31T-8104047N83MHStich Michael A · Malvern, OHBuilt 1969 · S/N 27-4302N83PAHill Enterprise Inc · Wilmington, DEBuilt 1981 · S/N 31-8112050N83RMPemc Air LLC · Evansville, INBuilt 1977 · S/N 34-7770265N83WCRegistered aircraftBuilt 1966 · S/N 27-3281N8401ACommercial Property Services Group LLC · Wichita, KSBuilt 1977 · S/N 421C0443N8401MRlv Industries Inc · Westerly, RIBuilt 1981 · S/N 34-8133137N8403JBlue Sky Investments LLC · Chokio, MNS/N 34-8133139N8403YBlair Robert A · Red Bluff, CABuilt 1967 · S/N 301552N8405YBjorkman Marvin S · Richardson, TXBuilt 1967 · S/N 30-1554N8406YPilgrim Robert C · Cape Coral, FLBuilt 1967 · S/N 30-1556N8407FPan Bar Aviation Inc · Pittsburgh, PABuilt 1976 · S/N 34-7770082N8407YAwad Aviation LLC · Pooler, GABuilt 1967 · S/N 30-1557N840ATAtp Taa LLC · Wilmington, DEBuilt 2023 · S/N 4496566N840JATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1985 · S/N 20800056N8410PMccoy Loyd R III · Richmond Hill, GAS/N 34-8133158N8413NFronek Brice A · Lake Havasu City, AZBuilt 1981 · S/N 34-8133162N8413TDmh Aviation LLC · Rochester, MIBuilt 1981 · S/N 34-8133170N8416YHenze Charles R · Waukee, IABuilt 1967 · S/N 30-1567N8417AGate 13 LLC · Santa Fe, NMBuilt 1981 · S/N 34-8133175N8417HWalser Air LLC · Warwick, RIBuilt 1981 · S/N 34-8133178N8418YHefner Joseph C · Mount Pleasant, TXS/N 30-1570N8419YMorrone Richard W · Westerly, RIS/N 30-1572N8421YKesser Gilbert M · Culpeper, VABuilt 1967 · S/N 30-1575N8426GWisconsin Aviation Inc · Watertown, WIBuilt 1981 · S/N 34-8133195N8427YBiernacki David F · Rockford, ILBuilt 1967 · S/N 30-1584N842DYAltimate Transportaton Services LLC · Dallas, TXFirst renewal noticeBuilt 1977 · S/N 421C0312N842NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 4496473N8430NFitch John A · Cary, ILBuilt 1978 · S/N 421C0490N8430YDavid Litteken · Aviston, ILBuilt 1967 · S/N 30-1588N8431YN8431y LLC · Coatesville, INBuilt 1967 · S/N 30-1589N8432HBt-Gs Aviation LLC · Baytown, TXBuilt 1981 · S/N 34-8133217N8432YTaylor Kyle F · Enterprise, ALBuilt 1967 · S/N 30-1591N8434MHenning George C Jr · Westlake, OHBuilt 1981 · S/N 34-8133220N8435YGlobal Aviators Academy Inc · Claremont, CAS/N 30-1595N8437NMattessich Martin J · Woodbridge, CTBuilt 1981 · S/N 34-8133233N8437UCavu Aviation LLC · Glenmont, NYS/N 34-8133235N8437YCool Air Investments LLC · Mission Hills, KSBuilt 1981 · S/N 34-8133236N8439ARuegger Pamela A · Beloit, WIBuilt 1981 · S/N 34-8133239N843DBDoan Creek LLC · Walla Walla, WABuilt 1978 · S/N 31T-7820090N843DCJuliet Echo LLC · Sheridan, WYBuilt 1965 · S/N 30-967N843GR & B Aircraft Holdings LLC · Denham Springs, LABuilt 1969 · S/N 30-1766N8441AAerolease LLC · Wilmington, DEBuilt 1963 · S/N 30-125N8443LM & M Aviation Services Ltd · Rock Falls, ILBuilt 1981 · S/N 34-8133252N8444CL&J Aviation Inc · Atwater, CABuilt 1981 · S/N 44-8107063N8444YBeacon Aviation Flight Services LLC · Rogers, ARS/N 30-1604N8446CKnierim John J · Puyallup, WABuilt 1976 · S/N 34-7670140N8449HDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1981 · S/N 34-8133267N8449LMichaels Wings LLC · Parker, COS/N 34-8133268N8449THoffman Westly James Trustee · Tucson, AZBuilt 1981 · S/N 34-8133272
Back to AD 2004-25-16 R1