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.

N50497Meurer Carl J · Little Rock, ARBuilt 1968 · S/N 15069347N504JRitter Michael W · Cumberland, MDBuilt 1974 · S/N 15076142N50502Behnke Randall · Manitowoc, WIS/N 15069351N50503Kelly Keith Austin · Oklahoma City, OKBuilt 1968 · S/N 15069352N50530Kelly John M · Gastonia, NCBuilt 1968 · S/N 15069376N50531Davies Patrick R · Trussville, ALBuilt 1968 · S/N 15069377N50532Cartagena Alfonso · Winter Springs, FLBuilt 1968 · S/N 15069378N50535Harrell Lewis H · Pontotoc, MSS/N 15069380N50538Dunes Aircraft Corporation Inc · Howell, MIS/N 15069382N50541W Air LLC · Wheeling, ILBuilt 1968 · S/N 15069384N50544Kidd Ronnie E · Ramseur, NCS/N 15069386N50550Registered aircraftS/N 15069391N50551Barreto Daniel · Enterprise, ALBuilt 1968 · S/N 15069392N50555Whalen John · West Ossipee, NHBuilt 1968 · S/N 15069396N50574Pope Gregory S · Jacksonville, ILBuilt 1968 · S/N 15069405N50577Diaz Ernesto · Oxnard, CABuilt 1968 · S/N 15069408N50578Mccann Michael H · Springfield, ORBuilt 1968 · S/N 15069409N50580Freeman Jeffrey E · Iron Mountain, MIBuilt 1968 · S/N 15069411N50581Pritchett Otis R · Avery, TXS/N 15069412N50583Registration Pending · Bentonville, ARRegistration pendingBuilt 1968 · S/N 15069414N50596Phillips John H · Vernal, UTBuilt 1968 · S/N 15069423N505CACarver David N · Sanger, CABuilt 1975 · S/N 15076821N505WAAtlanta Technical College · Atlanta, GABuilt 1976 · S/N 15077942N50606Siderwicz Christopher J · Marstons Mills, MABuilt 1968 · S/N 15069429N50610Henry Mark Alan · Dickinson, TXS/N 15069431N50614Walker William G Jr · Scottsdale, AZBuilt 1968 · S/N 15069434N50617Adventist World Aviation · Wilson, NCS/N 15069436N50618Clark Christopher W · Fallon, NVBuilt 1968 · S/N 15069437N50621Slade Michael · Lakeville, MABuilt 1968 · S/N 15069439N50624Davis Clint A · Fairland, INBuilt 1968 · S/N 15069442N50628Padgett Justin S · Fruithurst, ALBuilt 1968 · S/N 15069445N50629Boshart Stanley J · Albany, ORBuilt 1968 · S/N 15069446N50633Sherwood Ronald R · Kathleen, GABuilt 1968 · S/N 15069449N50641Jstram Lc · Sheridan, WYBuilt 1968 · S/N 15069454N50652Omlid Robert L · Watford City, NDBuilt 1968 · S/N 15069461N50663Zimna Grazyna · KrasocinS/N 15069467N50665Meneely Robert W · Los Altos Hills, CAS/N 15069469N50672Registered aircraftBuilt 1968 · S/N 15069476N50679Go Fly Ez LLC · Athens, OHBuilt 1968 · S/N 15069480N50688Hershey Andrew C · Manchester, NHBuilt 1968 · S/N 15069485N50691Layka'S Choice LLC · Lawrenceville, GABuilt 1968 · S/N 15069487N50695Mannfolk Steven M · Wingdale, NYS/N 15069489N50696Winsor Andrew · Medford, MAS/N 15069490N50697Cole Timothy Les · Las Vegas, NVBuilt 1968 · S/N 15069491N506DEAero Fliers LLC · Kalispell, MTBuilt 1977 · S/N 15279717N50704Fox Valley Technical College · Oshkosh, WIBuilt 1968 · S/N 15069496N50706Rhoades Charles E · Blessing, TXFirst renewal noticeS/N 15069498N50717Road Robert L · Fargo, NDBuilt 1968 · S/N 15069504N50720Smith Bruce Allan · Phelps, KYBuilt 1968 · S/N 15069506N50728Erickson Aeronautics LLC · Perry, IABuilt 1968 · S/N 15069512
Back to AD 2009-10-09 R2