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.

N6480GLloyd Trent E · Central Valley, UTBuilt 1970 · S/N 15071980N6480SKline James R · Kokomo, INBuilt 1967 · S/N 15067280N6481FWood James N · Samson, ALBuilt 1966 · S/N 15063081N64823Training Planes LLC · Tampa, FLS/N 15281438N6482KKimmel Timothy I · San Angelo, TXS/N 15077723N6482MSilver Express Co DBA · Miami, FLBuilt 1980 · S/N 15284750N64831Obregon Ernest · Oakley, CABuilt 1978 · S/N 15281442N6483FRegistration Pending · Seattle, WARegistration pendingS/N 15063083N6483GPeterson Cassandra L · Poplar Grove, ILBuilt 1970 · S/N 15071983N6483SBlue Skies Aviation Of Wi Inc · Pulaski, WIBuilt 1967 · S/N 15067283N64849Garcia Herbert A · Houston, TXBuilt 1981 · S/N 15285280N6484FGrant Clinton A · Portage Des Sioux, MOS/N 15063084N6485HBentley Dan G · Worcester, NYBuilt 1979 · S/N 15284170N6486GRomeo Aviation Inc · Cumberland, WIBuilt 1970 · S/N 15071986N6486LHarrison Ashley L · Danbury, CTS/N 15284414N6487GRedell Donald J · Lake Geneva, WIBuilt 1970 · S/N 15071987N6487SSouth Louisiana Community College · Lafayette, LABuilt 1967 · S/N 15067287N6488FLee Michael R · Kelso, WABuilt 1966 · S/N 15063088N6488GKrog Steven L · Hartford, WIBuilt 1970 · S/N 15071988N64891Executive Aircraft Resources LLC · Birmingham, ALBuilt 1978 · S/N 15281458N64893Weitzel Laury D · Meadow, TXBuilt 1978 · S/N 15281459N64898Fazzini Pamela A · Sedona, AZBuilt 1978 · S/N 15281464N6489MSouthern Illinois University Board Of Trustees DBA · Murphysboro, ILBuilt 1980 · S/N 15284753N64908Fauver Russell J · Hartsville, SCBuilt 1978 · S/N 15281470N6490LAlpha Aircraft International LLC · Lake Worth, FLS/N 15284417N64912Suburban Air Corporation · Castro Valley, CABuilt 1978 · S/N 15281473N6491KFisher Air LLC · Cardington, OHS/N 15077726N6492FSkywagon Aero LLC · Wilmington, DES/N 15063092N64939Street Paul G · Anniston, ALBuilt 1978 · S/N 15281487N64942Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15281489N64944Dsr-Cherokee 180 LLC · Dallas, TXBuilt 1978 · S/N 15281490N64949Heavy Metal Air LLC · Farmingdale, NYBuilt 1978 · S/N 15281494N6495KBauknecht Daniel P · Antigo, WIBuilt 1975 · S/N 15077730N6496GJbm Aviation LLC · Mc Leansboro, ILS/N 15071996N6496LTurn Key Aviation LLC · North Las Vegas, NVBuilt 1980 · S/N 15284420N64971R&R Aero Services LLC · Eden Prairie, MNBuilt 1978 · S/N 15281505N6497GLynch David C · Columbus, INBuilt 1970 · S/N 15071997N64985Keenan Jim · Neenah, WIBuilt 1978 · S/N 15281512N64987Stanford Jay J · St Marys, GAS/N 15281514N64988Southwinds Export Inc · Kissimmee, FLS/N 15281515N64989Verderame Robert A · Metairie, LABuilt 1978 · S/N 15281516N6499GSkadberg Christen G · Knife River, MNBuilt 1970 · S/N 15071999N64BBBlazey Brian I · Palmyra, NYBuilt 1967 · S/N 15066150N6500FMoore Howard W · Camden, TNBuilt 1966 · S/N 15063100N6500SSpitfire USA Ltd · Rockville, MDBuilt 1967 · S/N 15067300N6501FHoward James S · Arlington, TXS/N 15063101N6502SPetrosyan Joseph · Rancho Cordova, CABuilt 1967 · S/N 15067302N6503FStockton Ketron J · Bulls Gap, TNBuilt 1973 · S/N A1500446N6503HBrafford John Lee · Kings Mountain, NCBuilt 1979 · S/N 15284172N6503MCentral Texas College · Killeen, TXBuilt 1980 · S/N 15284759
Back to AD 2009-10-09 R2