OpenAirDocs.org
AD 2009-10-09 R2

Registered aircraft · 8,565

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:2009-10-09-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2009-10-09-R2')
  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.

N714FHPoliti Terris P · Lake Placid, NYBuilt 1976 · S/N 15079139N714FKSmokejumper Aviation LLC · Winthrop, WABuilt 1976 · S/N 15079141N714FMNorth Florida Flight School LLC · Tallahassee, FLBuilt 1976 · S/N 15079142N714FWPilot Rise Aircraft Holdings LLC · Fort Worth, TXBuilt 1976 · S/N 15079151N714GBBuchanan Michael Shane · Manchester, TNBuilt 1976 · S/N 15079155N714GDRose Robert J · Grosse Ile, MIBuilt 1976 · S/N 15079157N714GHStrauss Austin · Avon, OHBuilt 1976 · S/N 15079161N714GJOlson John W · Jackson, MNBuilt 1976 · S/N 15079162N714GKCashman Timothy J · Mercer Island, WAS/N 15079163N714GLHall Johnie S · Kingsland, ARBuilt 1976 · S/N 15079164N714GRStrine Russell A · Reading, PABuilt 1976 · S/N 15079169N714GUIrwin Roberta L · San Diego, CABuilt 1977 · S/N 15079172N714GYWilson William R · Halfway, ORS/N 15079176N714GZOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1977 · S/N 15079177N714HBJ11 Air LLC · Dallas, TXBuilt 1977 · S/N 15079179N714HHPhelps Clay DBA · Santa Paula, CABuilt 1977 · S/N 15079185N714HKDent Kelly J · Locust Grove, GABuilt 1977 · S/N 15079187N714HLSlate Mitchell P · Colorado Springs, COBuilt 1977 · S/N 15079188N714HRHendry Joshua R · Carthage, TNS/N 15079193N714HUSingh Paviter · Beavercreek, OHBuilt 1977 · S/N 15079196N714HYLeft Final LLC · Gastonia, NCS/N 15079199N714JMartinez Ivan · Oro Valley, AZBuilt 1977 · S/N 15079382N714JCAries Flyers Inc · Santa Clara, CABuilt 1977 · S/N 15079203N714JDGuthrie Bobby D · El Dorado, ARS/N 15079204N714JFMetcalf Christopher A · Meadowview, VABuilt 1977 · S/N 15079206N714JKDrouin Arnold R · Berlin, NHBuilt 1977 · S/N 15079210N714JLWestra Todd A · Ireton, IABuilt 1977 · S/N 15079211N714JPCp Aviation Inc · Santa Paula, CABuilt 1966 · S/N 15065030N714JTThompson John · Stevens Point, WIBuilt 1977 · S/N 15079217N714JXPiteck Timothy S · Battle Ground, WAS/N 15079221N714KEGustin Ralph P · New Smyrna Beach, FLFirst renewal noticeBuilt 1977 · S/N 15079228N714KKMcnally Robert H · Tulsa, OKS/N 15079233N714KMDavis Steven M · Eastsound, WABuilt 1977 · S/N 15079234N714KQBowser Dwight H · Anchorage, AKBuilt 1977 · S/N 15079237N714KRB2 W Corporation · Winona, MNBuilt 1977 · S/N 15079238N714KTCox Garry G · Coleman, TXS/N 15079240N714KUInsalaco Stephen C · Benson, AZS/N 15079241N714KWHerbert Michael S · Crawford, COBuilt 1977 · S/N 15079243N714KXLowder Harold E · Fresno, CABuilt 1977 · S/N 15079244N714KZGlomb Andrew · Las Vegas, NVBuilt 1977 · S/N 15079246N714LCCruz Martin G Jr · Prosper, TXBuilt 1977 · S/N 15079249N714LFRollins David M · Martinsville, INBuilt 1977 · S/N 15079252N714LPBlue Skies Time Builders LLC · Roy, WAS/N 15079260N714LRSt Johns Aviation LLC · Saint Johns, MIS/N 15079262N714LWMorcom Aviation Services Inc DBA · Everett, WABuilt 1977 · S/N 15079267N714LXMock Joseph R · Huntsville, TXBuilt 1977 · S/N 15079268N714LZKhosrovyan Rafayel · Fort Worth, TXS/N 15079270N714MWicked Wings LLC · Falls Of Rough, KYS/N 15079274N714MCAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 15079273N714MGManandhar Raj P · Hawthorne, CABuilt 1977 · S/N 15079277
Back to AD 2009-10-09 R2