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.

N5317YBaker Avery R · Bonifay, FLBuilt 1963 · S/N 27-2394N531ABMissionair Inc · Danbury, CTS/N TJ-454N531AMLippert Michael Thomas · California, MDBuilt 1962 · S/N 310G0097N531KCConstantine LLC · Fort Collins, COBuilt 1985 · S/N TH-1484N531MHigh Cotton Aero LLC · Murray, KYBuilt 1978 · S/N 340A0534N531QRegistered aircraftBuilt 1968 · S/N TC-1141N5320JCorporate Air Charter Inc · Wilmington, DEBuilt 1977 · S/N 340A0407N5320YRawareo LLC · Warsaw, MOBuilt 1963 · S/N 27-2397N5321RTexas State Technical College · Waco, TXFirst renewal noticeS/N 4496045N5322AD & J Aviation LLC · Apopka, FLS/N 4496081N5324JSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 340A0410N5325SR & H Aviation LLC · Shady Shores, TXBuilt 1966 · S/N 337-0425N5327SLowry Steve H · Sun River, MTBuilt 1966 · S/N 337-0427N5328JKahler Automation Corp · Fairmont, MNBuilt 1977 · S/N 340A0412N5328LUniversity Of Illinois · Savoy, ILBuilt 2001 · S/N 4496108N5329YFlying Fish Ranch 29y LLC · Leesburg, FLBuilt 1963 · S/N 27-2406N532AMGlassett Neal R · Dunlap, ILBuilt 1975 · S/N 34-7570191N532EBJeb Air LLC · Waverly, OHBuilt 1980 · S/N 414A0440N532QRoush James L · Medina, WABuilt 1968 · S/N TC-1160N532SJohnson Lucas G · Pleasant Lake, MIBuilt 1965 · S/N 27-2966N5330JTexas Airtime LLC · Fort Worth, TXS/N 310I0057N5331NUniversity Of Illinois · Savoy, ILBuilt 2001 · S/N 4496106N5331YHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2002 · S/N 4496163N5337TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250249N533ACEast Tennessee Aviation Services LLC · Harrison, TNBuilt 1978 · S/N 414A0103N533CEHoward David D · Winner, SDBuilt 1969 · S/N 310Q0034N533CHSwenson Roger A · Pahrump, NVS/N 340-0056N533GRocket Ride LLC · Yakima, WABuilt 1964 · S/N 310I0102N533KCTidd Scott · Reading, MIBuilt 1963 · S/N 27-2390N533STGentry Air LLC · Orlando, FLBuilt 1978 · S/N 414A0034N533WPJacobs Aviation LLC · Mt Juliet, TNS/N 340A0328N533YABb Aero Works Ltd · Whitehouse, OHBuilt 1968 · S/N 31-157N5340GLegal Limit Motor Sports LLC · Anderson, CAS/N 340A0421N53418N53418 LLC · Orlando, FLBuilt 1974 · S/N 33701611N5341ZAtp Aircraft 4 LLC · Wilmington, DEBuilt 2001 · S/N 4496107N53420Kropp Christian Trustee · Azle, TXBuilt 1974 · S/N 33701613N5342SFranco Gloria J · Las Vegas, NVS/N 337-0442N53434Caswell Jeff S · Durham, CABuilt 1974 · S/N 33701621N53449Hyde Russell M · Rutherfordton, NCS/N 33701631N5344VSeneca Holdings LLC · Mesa, AZBuilt 2002 · S/N 3449239N5344YMerced County Mosquito Abatement District · Merced, CABuilt 1963 · S/N 27-2418N5346JCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1977 · S/N 340A0419N53475Rw Aviation LLC · Fishers, INBuilt 1975 · S/N 33701649N534MAPn4 Aviation Holdings LLC · Bishop, CABuilt 2003 · S/N 3449278N534QKenney Aviation LLC · Osterburg, PABuilt 1968 · S/N TC-1176N53504Aviation Adventures LLC · Hansen, IDBuilt 1975 · S/N 33701664N5350GSmolin Matthew R · Durango, COS/N 3449246N53510Joey Os LLC · Darlington, PABuilt 1975 · S/N 33701670N53519Gic Inc · Oneill, NEBuilt 1975 · S/N 33701677N53520Harben Grover S III · Gainesville, GAS/N 33701678
Back to AD 2004-25-16 R1