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.

N488UVUtah Valley University · Orem, UTBuilt 2018 · S/N 4496451N4893PTri-City Helicopter Services Inc · Richland, WABuilt 1961 · S/N 27-477N4895PKlein Barry A · Friday Harbor, WABuilt 1961 · S/N 27-482N4899PC E S Corporation · Charleston, WVRevoked, canceledBuilt 1961 · S/N 27-487N489TCFishstix Aviation LLC · Apopka, FLS/N 31-8312004N48AMGwc Air LLC · Madison, ALBuilt 1980 · S/N 414A0609N48ARGacey Inc Trustee · Wilmington, DEBuilt 1966 · S/N 30-1328N48BPRossman Richard J DBA · Glenview, ILBuilt 1975 · S/N 421B0957N48CCC Baron LLC · Lafayette, LAFirst renewal noticeBuilt 1981 · S/N TH-1277N48CPDouglas Aviation Ltd · South Barrington, ILS/N 421C0902N48GCRoyal Air Inc · Shreveport, LABuilt 1970 · S/N P167N48JClever Conceptz LLC · Danbury, CTS/N TH-409N48LJSga Alaska Leasing LLC · Anchorage, AKBuilt 1977 · S/N 347770030N48SLLauff Samuel Jr · Ocala, FLBuilt 1975 · S/N 34-7570042N48TXCulater LLC · Indianapolis, INBuilt 1985 · S/N TH-1493N48WCBaron Acquisition LLC · Wayne, PABuilt 1981 · S/N TJ-350N48YKimble Robert · Marco Island, FLBuilt 1981 · S/N 27-8154022N4904PCivil Air Support LLC · Phoenix, AZBuilt 1961 · S/N 27-495N4907PTabor Conor C · Littleton, COBuilt 1961 · S/N 27-498N4907TPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250184N490KMRasf414 LLC · Hallandale Beach, FLS/N 414-0399N4910Vizas Global LLC · Grosse Pointe Park, MIBuilt 1977 · S/N 31-7752183N4916PPiper Aviation Museum Foundation · Lock Haven, PABuilt 1962 · S/N 27-506N4917AAtp Aircraft 7 LLC · Wilmington, DEBuilt 2008 · S/N 4496254N491NDChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 4496236N491WMRenlim Aviation LLC · Brookhaven, GABuilt 1985 · S/N TJ-491N4920PDetert Bradley · Valparaiso, INBuilt 1962 · S/N 27-510N4921PAndre David E · San Jose, CABuilt 1962 · S/N 27-511N492NDChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 4496241N492WAirplane Adventures LLC · Palos Heights, ILBuilt 1956 · S/N 23-611N4930PRegion Flyers LLC · Valparaiso, INS/N 27-523N4933AAir Data Solutions LLC · Natchitoches, LAS/N 23-1718N4934PAlm Holding LLC · Winton, CABuilt 1963 · S/N 27-527N4938SAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1982 · S/N 31T-8166050N493DVSatterfield Thomas J · Ewing, ILBuilt 1979 · S/N TJ-218N493JHBrooklyn LLC · Parker, COS/N 421C0860N4940PArpey Aviation Ltd · Colleyville, TXBuilt 1963 · S/N 27-535N4942PSchulz Beverly A · Merrill, WIBuilt 1963 · S/N 27-537N4945MMidland College · Midland, TXBuilt 1978 · S/N TJ-145N4949CHatchie River Aviation LLC · Kalispell, MTBuilt 1982 · S/N T30300128N4949PSonn Jeffrey R · Descanso, CAS/N 27-545N4949YPearce Richard Henry · Moses Lake, WAS/N 30-648N494NJT And B Flying Adventures LLC · Middletown, DES/N 30-494N494TSDeep Creek Lake Ventures LLC · Oakland, MDBuilt 1983 · S/N T30300201N494WKingsbury Raymond S · Farmington, MNS/N 310K0103N495495htsi LLC · Wilmington, DEBuilt 1980 · S/N 414A0487N4951PKnights Aviation Services LLC · Westlake, OHBuilt 1963 · S/N 27-547N4955PJuber Glenn E · Coconut Creek, FLBuilt 1963 · S/N 27-555N4961PSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1963 · S/N 27-562N4965PKittner Robert T · Ellenville, NYBuilt 1963 · S/N 27-566
Back to AD 2004-25-16 R1