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.

N458SCAb Prop Plane I LLC · Metairie, LABuilt 2019 · S/N 4496490N458SSSos Ranch LLC · Humble, TXBuilt 1975 · S/N TH-569N458VCWing And A Prayer LLC · Sarasota, FLBuilt 1974 · S/N 421B0915N4590SConner Chad E · Paris, TNBuilt 1975 · S/N TH-676N4592SMays Robert · Centerville, TNBuilt 1976 · S/N TJ-87N4597PGv Air Inc · Medford, ORBuilt 1960 · S/N 27-107N4599FCcs Flight Services LLC · Benton Harbor, MIS/N 340A0652N459DMStafford Wings LLC · Fredericksburg, VABuilt 1981 · S/N 421C1084N459SCAb Prop Plane I LLC · Metairie, LABuilt 2019 · S/N 4496492N45BBSpeer Aircraft LLC · Evansville, INBuilt 1979 · S/N 421C0661N45CWRobertson Scott · Chappell Hill, TXBuilt 1970 · S/N TC-1319N45EEVazarani Sarah · Concord, MABuilt 1971 · S/N TH-185N45FMBurgner Vanessa C · Belleville, MIBuilt 1976 · S/N TH-739N45JLBows Investments LLC · Bend, ORS/N 39-148N45JRJmf Inc · St Maries, IDBuilt 1976 · S/N 421C0109N45MJFollowell Robert L · Germantown, TNS/N 31-7912104N45MTTimp Trails Ltd LLC · Orem, UTBuilt 1977 · S/N 347770233N45PTCleaver Anthony M · Boulder, COBuilt 1976 · S/N TH-727N45SDEast Hill Seneca LLC · Ithaca, NYBuilt 1981 · S/N 34-8233016N45TFWave Transportation LLC · Middletown, DEBuilt 1982 · S/N 340A1507N4604NS O W Aviation LLC · Crystal River, FLBuilt 1980 · S/N 340A1016N4607MClark Jean F Trustee · North Falmouth, MABuilt 1978 · S/N TH-938N460SCFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 4496551N4610WTen Right Aviation LLC · Abbeville, LAS/N TH-1378N4614PHull John W Jr · Palmdale, CABuilt 1960 · S/N 27-126N4615SMurrer Aviation Inc · Canonsburg, PAS/N TH-685N4618MBedrock Siteworks LLC · Coatesville, PABuilt 1978 · S/N TJ-150N4619MNfv LLC · Helena, MTBuilt 1978 · S/N TH-918N461BCB&K Leasing Inc · Nantucket, MABuilt 1992 · S/N TH-1661N4621MBassline Logistics LLC · Watauga, TNS/N TH-919N462DHFly Live Charter Inc · Fort Lauderdale, FLS/N 31-7952218N462TTAir Enterprises LLC · Dover, DEBuilt 1968 · S/N 27-4042N4630PGoodfellow Ian A · Palm Beach Gardens, FLBuilt 1960 · S/N 27-148N4631PO'Neill Daniel C · Tumwater, WAS/N 27-149N4635GN535j LLC · Bismarck, NDBuilt 1977 · S/N 414-0906N4636PV1 Iowa Aviation LLC · Des Moines, IAS/N 27-155N4638ATropical Air Lease LLC · Hialeah, FLBuilt 1971 · S/N TC-1408N463DBThunderhook Air Inc · Brentwood, TNBuilt 2009 · S/N 20800505N463KBBuster Air LLC · Miami, FLBuilt 1972 · S/N TH-278N4640GHonea Richard S · Canton, GABuilt 1976 · S/N 414-0908N4642PColumbus Sign Co · Columbus, GAS/N 27-163N4644PFennema Alan A · San Jose, CABuilt 1960 · S/N 27-165N4645GAnderson Cattle Co Inc · Emporia, KSS/N 414-0913N4647SJnjz Enterprises LLC · The Woodlands, TXBuilt 1975 · S/N TC-1910N464DCDelta Charlie Aviation LLC · Glendale, AZBuilt 1979 · S/N 421C0709N464VCraig Michael · Port Orchard, WAS/N TC-1028N4650PCornejo Bernard J · Elko, NVS/N 27-173N4650SMeno Brian P · Collinwood, TNBuilt 1975 · S/N TC-1907N4657ATessos Air Service Inc · Wilmington, DES/N TH-41N465CWSkyking LLC · Lake Stevens, WABuilt 1963 · S/N 310H0134
Back to AD 2004-25-16 R1