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.

N639SCSale Reported · Glen Allen, VASale reportedBuilt 1969 · S/N 421A0102N63AHApm Leasing LLC · Casper, WYBuilt 1977 · S/N 34-7870007N63CXAerodata LLC · Wilmington, DES/N 4140388N63DBDelta Properties Llp · Nogales, AZS/N 414A1211N63DETri-Air LLC · Cedartown, GABuilt 1972 · S/N 310Q0675N63ECAugend Arsalan · Chicago, ILBuilt 1976 · S/N 340A0121N63ENEcho November Inc Trustee · Wilmington, DES/N 340-0063N63LTGlobal Green Initatives LLC · Houston, TXS/N 27-7754100N63MABarlo Management Group LLC · Winona, MSBuilt 1964 · S/N TC-719N63RJDratler Stanley M · Fort Myers, FLBuilt 1974 · S/N TC-1804N63TTBrothers Aviation Va LLC · Manassas, VABuilt 1981 · S/N 31-8152026N6400YAztec Flyers LLC · Zephyrhills, FLBuilt 1967 · S/N 27-3685N6401HBooskye LLC · Dumas, TXBuilt 1981 · S/N TJ-401N6401YBudd Richard E · Brooksville, FLBuilt 1967 · S/N 27-3686N6404YUphold Thomas R · Arlington, TXBuilt 1968 · S/N 27-3897N6408QAftershock Marketing Inc · Henryville, PABuilt 1982 · S/N TJ-408N640ACPlane Old LLC · Wildwood, MOBuilt 1974 · S/N TH-458N6412XFucaimo LLC · South Pasadena, CAS/N TJ-412N6416YMcm Aviation LLC · Estero, FLBuilt 1967 · S/N 27-3708N6418YWalker Gilbert R · Brentwood, TNBuilt 1967 · S/N 27-3710N641PSSmith Michael J · Napa, CABuilt 1979 · S/N ME-155N64200D&G Baron LLC · Helena, ARBuilt 1982 · S/N TJ-420N642WAGunnslinger Air LLC · Destin, FLBuilt 1979 · S/N 31-7952084N6430YFord William E · Minnetonka, MNBuilt 1967 · S/N 27-3728N64310Aldrich Curtiss R · Big Oak Flat, CABuilt 1964 · S/N 310I0134N643SCRegistered aircraftBuilt 1970 · S/N 31P-7N643WMBarham Investments LLC · Dexter, MOBuilt 1985 · S/N 414A1205N6446NB55 LLC · Lawrenceville, GAFirst renewal noticeBuilt 1982 · S/N TC-2454N644ACTwin Poles Aviation LLC · East Setauket, NYBuilt 2002 · S/N 3449261N644KSKent State University · Stow, OHBuilt 2006 · S/N 4496220N6458CMb/F Inc · Greensboro, NCBuilt 1985 · S/N TH-1495N645RD&S Development LLC · Spring, TXBuilt 1964 · S/N 30-240N645SCDeaton Dennis · Glen Allen, VAS/N 31P-22N645SDDacy Julia A · Harvard, ILBuilt 1964 · S/N 30-524N645SKBendavid Gary · Oak Bluffs, MAS/N TH-2118N645WCWest Louis G · Amity, ORBuilt 1975 · S/N 414-0645N6460YRogers Anthony J · Boynton Beach, FLBuilt 1967 · S/N 27-3754N646SCRegistered aircraftBuilt 1970 · S/N 31P-33N6472YNorman Robert Alan · Zanesville, OHBuilt 1967 · S/N 27-3767N647TWWeigle Gerald V Jr Trustee · Cincinnati, OHBuilt 1973 · S/N 310Q0815N6480YTechnical Education Services Inc · Virginia Beach, VABuilt 1967 · S/N 27-3776N6485YMeluskey Michael · Christiansted, VIBuilt 1967 · S/N 27-3782N6486VVroom Engineering Inc · Tucson, AZBuilt 1984 · S/N T30300311N648SBHays Kelly · Dumas, TXBuilt 1979 · S/N 421C0648N648SCDeaton Dennis · Glen Allen, VAS/N 31P-7300143N6494CKaminicki Craig G · Monticello, ARBuilt 1978 · S/N 34-7870161N6498VSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1984 · S/N T30300313N649ECDriggers David M · Tifton, GABuilt 1981 · S/N TH-1323N649LCSmith Aviation LLC · Sitka, AKBuilt 1980 · S/N TJ-304N649SCDeaton Dennis · Glen Allen, VAS/N 31P-7400184
Back to AD 2004-25-16 R1