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.

N89BRN89br LLC · Wilmington, DEBuilt 1967 · S/N 27-3618N89GPanousis Steve · Kennett, MOBuilt 1975 · S/N TH-616N89JASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 31T7920030N89SDState Of South Dakota · Pierre, SDBuilt 1979 · S/N 34-8070089N89SLMclain Scott S · East Troy, WIBuilt 1956 · S/N 23-602N89VVAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1973 · S/N 27-7405254N8APMatthews Aviation LLC · Hardinsburg, KYBuilt 1973 · S/N 27-7305072N8AVOtis Air Service Inc · Wichita, KSBuilt 1974 · S/N 421B0663N8BFEight Bravo Foxtrot LLC · Shafter, CAS/N 310J0140N8BLPro One Janitorial Inc · Chicken, AKBuilt 1970 · S/N 414-0098N8BULakeair LLC · Richland, MIBuilt 1970 · S/N TC-1322N8CTOpitz Airways Inc · Belleair, FLBuilt 1973 · S/N 27-7305094N8DPDelta Papa Aviation LLC · Wilmington, DES/N TH-1038N8EHMcdougall Butch · Pocatello, IDFirst renewal noticeBuilt 1965 · S/N 320C0063N8EPN8ep LLC · Spring Hill, FLBuilt 1973 · S/N 310Q0967N8FTop Flight Aviation Inc · Corona, CAS/N 30-1312N8GALambeth Air LLC · Sitka, AKS/N 421C0842N8HMMetco Builders LLC · Edmond, OKS/N 414-0620N8HTServicetec LLC · Kalamazoo, MIBuilt 1978 · S/N 421C0618N8LBHill Mark Daniel · Magnolia, TXBuilt 1969 · S/N 30-1788N8MSFlagg Robert F · Castro Valley, CABuilt 1961 · S/N 23-1993N8MZSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1967 · S/N 301648N8NGRetail Contracting Group Inc · Oakdale, MNBuilt 1969 · S/N TH-19N8PXFly Casual LLC · Sacramento, CABuilt 1972 · S/N 39-144N8SSWeather Modification LLC · Fargo, NDBuilt 1973 · S/N 340-0191N8TCSvenningsen Joshua J · Spring Hill, FLS/N 310Q0264N8TDCaldwell Henry H Jr · Las Vegas, NVS/N 34-7770257N8TMAdvanced Intelligent Computing Inc DBA · Houston, TXBuilt 1980 · S/N TJ-325N8URLoberg Kirk · Jonesboro, ARBuilt 1999 · S/N TH-1917N8WBSmartin Enterprises LLC · Clackamas, ORBuilt 1974 · S/N 421B0594N8WWLcam Aviation LLC · Springfield, MOBuilt 1976 · S/N TK-43N9001QSaransor Properties LLC · Eden Prairie, MNBuilt 1970 · S/N TH-57N9005SKd3 LLC · Dubois, WYBuilt 1965 · S/N TC-954N900AMGimli Son LLC · Fort Lauderdale, FLBuilt 1979 · S/N 27-7954014N900CBHnl Group LLC · Minnetonka, MNS/N 421C0837N900CGMarc Inc · Bolton, MSBuilt 1975 · S/N 31-7612002N900DCRognerud Edward J · Rosemount, MNBuilt 1970 · S/N 39-20N900DDN900dd Inc · Ramona, CAS/N 34-7970270N900GGVeetwo Inc · Merritt Island, FLS/N 3433020N900KBN900kb LLC · California, MDBuilt 1977 · S/N TH-863N900NXAlva Family Holdings LLC · Fort Denaud, FLBuilt 1976 · S/N TH-723N900PTGoblirsch Randy J · Sleepy Eye, MNBuilt 1973 · S/N 31P-7400176N900SHShadowline Aviation LLC · Wilmington, DEBuilt 1979 · S/N 414A0460N900TCBlanco James A · El Dorado Hills, CABuilt 1976 · S/N 340A0210N900TSMidwest Flying Service Inc · Sheldon, IABuilt 1974 · S/N 27-7405429N900VStratus Financial LLC · Irvine, CABuilt 1964 · S/N TC-803N900WWBucher Burton · North Chicago, ILBuilt 1966 · S/N 27-3372N9011VStar Equipment Leasing LLC · Huntsville, ALBuilt 1968 · S/N TC-1157N9017SParker Joshua T · Fort Worth, TXBuilt 1965 · S/N TC-962N9018VTsubasa Aviation LLC · Hooper, UTBuilt 1969 · S/N TC-1296
Back to AD 2004-25-16 R1