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.

N7208VMeyer Ag Aviation Inc · Whittemore, IABuilt 1984 · S/N TH-1432N7209BFly By Knight Inc · Hammond, LABuilt 1984 · S/N TH-1428N7209YThy Will Be Done Here LLC · Reno, NVBuilt 1963 · S/N 30-235N720FSVero Executive Flyers Inc · Fort Pierce, FLS/N 421C1250N720LRegistered aircraftBuilt 1968 · S/N 320F-0042N720SBWhalen John F Jr · West Ossipee, NHS/N 337-0407N720SUOklahoma State University · Stillwater, OKBuilt 2017 · S/N 4496413N720WCSw Aviation LLC · Wilmington, DEBuilt 1991 · S/N TH 1624N7210CUpupair LLC · Raleigh, NCBuilt 1984 · S/N TH-1431N72113N72113 LLC · Harrah, OKS/N 33701521N7211YBeers Jason · Girard, OHS/N 30-237N7215RBarnhart William C III · Whitewood, SDBuilt 1976 · S/N TC-1944N7216REncore Air LLC · Dover, DEBuilt 1974 · S/N TC-1820N7216YMerriwether David E · Whitesburg, GABuilt 1963 · S/N 30-242N7217HMaine Instrument Flight · Augusta, MEBuilt 1984 · S/N TH-1442N7219HGrandview LLC · Columbus, MSBuilt 1984 · S/N TH-1447N721CEErtel Thomas H · Charlotte, NCBuilt 1980 · S/N 31-8112002N721CVDvf Ventures LLC · Alapaha, GABuilt 2004 · S/N TH-2078N721HBBrazilco Aviation LLC · Missouri City, TXS/N 421C0629N721JSWolansky Brad · Plant City, FLBuilt 1997 · S/N 3449024N721LTWhite River Holdings LLC · Southaven, MSBuilt 1983 · S/N TH-1387N721SJAir America Flight Center LLC · Daytona Beach, FLBuilt 1973 · S/N 310Q0721N721VGB & W Aerial Spray Inc · Dimmitt, TXS/N 421B0847N721YGRunway Aviation Flight Training USA Corp · Rockwall, TXBuilt 1974 · S/N 340-0342N7220JMuddy Waters LLC · Pompano Beach, FLBuilt 1984 · S/N TH-1449N7220UFlying R Aviation LLC · Smackover, ARS/N TH-1451N7222LAllmon William C · Las Vegas, NVFirst renewal noticeS/N TJ-484N72235Blass Robert · New Smyrna Beach, FLBuilt 1985 · S/N TH-1457N7223BAmerican National University Inc · Salem, VABuilt 1985 · S/N TH-1443N7223YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1985 · S/N TH-1456N7224YDistel Harold M · Williamson, GABuilt 1964 · S/N 30-246N72250Anderson Gilbert Lc · Palm Bay, FLS/N 33701548N72252Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1985 · S/N TH-1460N7225HCosmo Plastics Company · Pepper Pike, OHBuilt 1985 · S/N TJ-485N7225RWalker Michael E · Lewistown, MTBuilt 1974 · S/N TH-550N7225YTwin Cam Holdings LLC · Union City, TNBuilt 1964 · S/N 30-248N7226YGilbert Douglas A · Weston, FLBuilt 1964 · S/N 30-249N7227YClearview Aerial Solutions LLC · Rogersville, TNS/N 30-250N72298Ronald D Mcgill Farms Inc · Klamath Falls, ORS/N 33701556N7229CLietzke Gerald P · Geneva, FLS/N TH-1469N722AGLdg Aviation LLC · Carefree, AZFirst renewal noticeBuilt 1977 · S/N TH-799N722JWMcintosh Kenneth V · Pleasant Plain, OHBuilt 1962 · S/N 27-2040N722PSSzendrey James J · Glendale, AZBuilt 1978 · S/N 34-7870125N722RATotal Prf LLC · Lewes, DEBuilt 1972 · S/N 34-7250352N722WCS & T Aviation LLC · Missoula, MTS/N 31-8052166N7230YVyas Shiven P · Chino Hills, CABuilt 1964 · S/N 30-254N7232HCu Tigers Fly LLC · Greensboro, NCBuilt 1985 · S/N TH-1476N7233YPacific North Air LLC · Portland, ORBuilt 1964 · S/N 30-257N72342Ampaire Inc · Long Beach, CABuilt 1973 · S/N 33701567N7235UWohdet LLC · Farmington, MOBuilt 1985 · S/N TH-1481
Back to AD 2004-25-16 R1