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.

N588NDChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 4496233N588PAirstar LLC · Lees Summit, MOBuilt 1994 · S/N TH-1725N588RRGay Don F · Terrell, TXBuilt 1966 · S/N 310K0091N588TBac LLC · Aliceville, ALBuilt 1977 · S/N TH-791N588TBVlot Cole T · Wellington, NVBuilt 1976 · S/N 421C0064N5896YPatentcentral LLC · Hollywood, FLBuilt 1965 · S/N 27-3051N589DMGeorgescu Radu A · Louisville, KYS/N 310Q1048N589NDUniversity Of North Dakota John D Odegard School · Grand Forks, NDBuilt 2026 · S/N 4496635N589PUniversity Of Central Missouri · Warrensburg, MOBuilt 1989 · S/N TH-1559N589RBDukas Air LLC · Fort Lauderdale, FLBuilt 1977 · S/N TJ-89N589STCurtis & Son Vacuum Service Inc · Liberty, TXS/N 421C0644N589YDennis Aviation LLC · Bartlett, TNBuilt 1977 · S/N TH-852N58ARAnnis Aviation LLC · Gray, GABuilt 1987 · S/N TH-1525N58AWAmplatz Left Aviation LLC · Rapid City, SDS/N 414A0276N58BESouth Georgia Air LLC · Valdosta, GAS/N TH-2055N58BJJmp Aviation Corp · Dover, DES/N 340A0723N58BNMinus 7 Inc · Boulder, COBuilt 1979 · S/N TK-99N58BPN7ss LLC · Nashville, TNBuilt 1978 · S/N TJ-176N58BSJordan Corporation · Jackson, MIS/N TH-1142N58BYFry Shawn Trustee · Baxter, TNBuilt 1970 · S/N TH-25N58CHChase Brandon C · Plains, KSBuilt 1978 · S/N TH-949N58CKMajestic Fleet LLC · Miami, FLBuilt 1974 · S/N TH-567N58DAUniversity Of Central Missouri · Warrensburg, MOBuilt 1984 · S/N TH1402N58DCDream Air LLC · Jonesboro, ARBuilt 1981 · S/N TH-1206N58DFB727 LLC · Midland, TXBuilt 1984 · S/N TJ-453N58DLHam John T · Murfreesboro, TNBuilt 1975 · S/N TH-692N58ELN1107u LLC · Lewisville, NCBuilt 1979 · S/N TH-1003N58EVLittle Tree Aeromotive LLC · Banner Elk, NCBuilt 1976 · S/N TH-704N58GELje Air LLC · Park Ridge, ILBuilt 1985 · S/N TH-1480N58GFCollier Air LLC · Fernandina Beach, FLBuilt 2004 · S/N TH-2095N58GKMvm LLC · Lewes, DEBuilt 1976 · S/N TH-763N58GWAlpha Whiskey LLC · Easton, PAS/N TH-2048N58HBjk Aviation LLC · Morgantown, WVBuilt 1979 · S/N 414A0314N58HCMedina Sky LLC · Medina, OHBuilt 1975 · S/N TH-637N58HDRoberts John E · Naples, FLBuilt 1979 · S/N TJ-230N58HESoaring Ventures LLC · La Quinta, CABuilt 1977 · S/N TK-59N58HMA Great Bonanza LLC · Manchaca, TXBuilt 1979 · S/N TJ-205N58HWHotel Whiskey LLC · Sylvania, OHS/N TH-2058N58JASunergy Solutions LLC · Londonderry, NHBuilt 1975 · S/N 3400521N58JDGrossman Kenneth R · Merced, CABuilt 1977 · S/N TK-19N58JGRvr600 Holdings LLC · Mount Dora, FLBuilt 1982 · S/N TJ-416N58JMLucky 7 Operating LLC · Many, LAS/N TK-142N58JZAcv Group LLC · Mckinleyville, CABuilt 1976 · S/N TH-710N58KERacego Corp · San Juan, PRBuilt 1978 · S/N TH-921N58KMOjito Osvaldo A · Miami, FLBuilt 1974 · S/N 27-7405440N58KTBarron Equipment Leasing LLC · Port Washington, NYBuilt 2000 · S/N TH-1955N58LDHenderson Leon Jr · Ellisville, MSBuilt 1985 · S/N TH-1472N58LFAckley Ray · Charlotte, NCBuilt 1972 · S/N TH-237N58LGMorgan Farms LLC · Twin Falls, IDBuilt 1981 · S/N TJ-393N58LPPrichard Lev H · Dallas, TXBuilt 1985 · S/N TJ-481
Back to AD 2004-25-16 R1