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.

N16017Maley Adam W · Shinnston, WVBuilt 1972 · S/N 15073415N1601QHesse Ginger C · Stacy, MNBuilt 1971 · S/N 15072901N16026B&R Aircraft LLC · Wadsworth, OHBuilt 1972 · S/N 15073422N16029Cabrera Ramon F · Guttenberg, NJBuilt 1972 · S/N 15073424N16033Mccosh Hunter B · Fort Wainwright, AKBuilt 1972 · S/N 15073427N16042Weaver Peter D · Davis, CABuilt 1972 · S/N 15073434N16045Dragseth Joseph M · Kenai, AKS/N 15073437N16046Sky Walker Flight School LLC · Adrian, MIBuilt 1972 · S/N 15073438N16048Maki Eric · Duncanville, TXBuilt 1972 · S/N 15073440N16049Hasselbring Ted · Nashville, TNBuilt 1972 · S/N 15073441N1604QBuck Fifty LLC · Freeport, ILBuilt 1971 · S/N 15072904N16051Wells Michael Perry · Thompson Falls, MTBuilt 1972 · S/N 15073442N16053Drain Dennis R · Ferndale, WABuilt 1972 · S/N 15073444N16057Renner Thomas J · Williston, NDS/N 15073447N16058Northwest Wings LLC · Hillsboro, ORBuilt 1972 · S/N 15073448N16064Wyatt Scott A · Tehachapi, CABuilt 1972 · S/N 15073451N1606QChappell Nathan T · Glasgow, MTBuilt 1971 · S/N 15072906N16073Hobbs Mitchell J · The Villages, FLBuilt 1972 · S/N 15073456N16074Derstine Ernest B · Pantego, NCS/N 15073457N16079El Ghawi Andre · Venice, FLBuilt 1972 · S/N 15073461N16080150 Flyers LLC · Waterford, MIFirst renewal noticeS/N 15073462N16084Lawson Roger E · Elizabethtown, KYBuilt 1972 · S/N 15073465N16088Wyrosdick Benjamin S · Hoover, ALBuilt 1972 · S/N 15073467N16091Timm Mark W · Ithaca, NEBuilt 1972 · S/N 15073469N16093Hanus Aviation LLC · Kenyon, MNBuilt 1972 · S/N 15073471N16097Crosswind Capital LLC · Castle Rock, COBuilt 1972 · S/N 15073474N160CBBishop Christopher S · Houston, TXBuilt 1966 · S/N 15063780N160KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1976 · S/N 15078474N16101Hatch David G · Clovis, CAS/N 15073477N16105Stevenson Rodrick Albert · Smyrna, GABuilt 1972 · S/N 15073480N16107Scheck Robert C · Chicago, ILBuilt 1972 · S/N 15073481N16108Longsroad LLC · Carefree, AZBuilt 1972 · S/N 15073482N16109Registration Pending · Mundelein, ILRegistration pendingBuilt 1972 · S/N 15073483N16114Mcquaid Joseph D · Cosby, TNS/N 15073486N16120Av8 Flight Assets LLC · Eden Prairie, MNBuilt 1972 · S/N 15073491N16125Palmer Earl S Jr · Boise, IDBuilt 1972 · S/N 15073494N16127Skypark Inc · Wadsworth, OHBuilt 1972 · S/N 15073496N16128Marquette County Flying Club · Marquette, MIBuilt 1972 · S/N 15073497N16129Rankin Kevin · Maryville, MOBuilt 1972 · S/N 15073498N16165Registered aircraftBuilt 1972 · S/N 15073514N16166Hayden Scott M · Walworth, WIBuilt 1972 · S/N 15073515N16169Trotter Patrick J · North Las Vegas, NVBuilt 1972 · S/N 15073518N1616QKrehbiel Bradley C · Lake City, MNS/N 15072916N16174Cirrostrats Inc · Deland, FLBuilt 1972 · S/N 15073523N16177Norby Aviation LLC · Hopkinton, MABuilt 1972 · S/N 15073525N16179Farrell Donald A · Owasso, OKBuilt 1972 · S/N 15073527N1617QAljanabi Mohammed Khalid · Herndon, VAS/N 15072917N16180Last Mango Air LLC · Fond Du Lac, WIBuilt 1972 · S/N 15073528N16184Finkel David M · Shelbyville, INS/N 15073530N16194Booth Jesse R · Alamosa, COBuilt 1972 · S/N 15073537
Back to AD 2009-10-09 R2