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.

N66439Mancini James N · Baltimore, MDBuilt 1974 · S/N 15076051N6643FAyresouth Aviation Inc · Lithia Springs, GABuilt 1966 · S/N 15063243N6643GStokes Patricia A · Nenana, AKFirst renewal noticeBuilt 1970 · S/N 15072143N66440Tenenboym Dennis Alexander · Pinellas Park, FLBuilt 1974 · S/N 15076052N6644GLive2flyfl Inc · Wilmington, DEBuilt 1970 · S/N 15072144N66452Bedard Michael J Trustee · Madison, ALBuilt 1974 · S/N 15076059N66453Beaudry Phillip H · Newport, VTBuilt 1974 · S/N 15076060N66455Soendergaard Carsten · Aguila, AZBuilt 1974 · S/N 15076061N66459Amelia Reid Aviation LLC · San Jose, CABuilt 1974 · S/N 15076063N66463Sikkema Romke P · Sebring, FLBuilt 1974 · S/N 15076065N66467Joe Dory Aviation LLC · Star, IDS/N 15076068N66469Pirtle Sandra Rinehart · Winnsboro, TXBuilt 1974 · S/N 15076070N6646GJenkinson Jeffery J · Montgomery, TXS/N 15072146N66472Bgmaviate LLC · Fairfax, VABuilt 1974 · S/N 15076072N66478Mason John M · Gilbert, AZBuilt 1974 · S/N 15076074N66479Gardner John F · Lyons, NYFirst renewal noticeS/N 15076075N66494Graham Luke R · Rushville, NEBuilt 1974 · S/N 15076081N66501Sanders Robert M · Youngsville, NCBuilt 1974 · S/N 15076084N66502Dewey Holdings LLC · Florence, ALBuilt 1974 · S/N 15076085N66506Scott John J · Arcadia, FLBuilt 1974 · S/N 15076086N66507Gozdowski Matthew D · Sylvania, OHS/N 15076087N66511Rawaero LLC · Warsaw, MOS/N 15076091N66516Mangon Aircraft Inc · Petaluma, CABuilt 1974 · S/N 15076094N66517Sugiond Yudi S · Redlands, CABuilt 1974 · S/N 15076095N66526Latimer Mary M · Vernon, TXBuilt 1974 · S/N 15076101N66536Ozark Management Inc · Jefferson City, MOBuilt 1974 · S/N 15076105N66537Woody Oran R · Conroe, TXBuilt 1974 · S/N 15076106N66539Vargas Serrano Marco Leandro · Roosevelt, UTS/N 15076108N6653FKerns Christopher R · Chillicothe, OHBuilt 1966 · S/N 15063253N66541Hardison Samuel H Jr · Mountain View, ARBuilt 1974 · S/N 15076110N66548Thompson Thurman B · Spencer, VAS/N 15076115N6654GAviation Trust Co LLC Trustee · Oklahoma City, OKS/N 15072154N6654SNick Franke LLC · Jacksonville, ARBuilt 1967 · S/N 15067454N66550Corcoran Timothy J · Aurora, ORBuilt 1974 · S/N 15076116N66551Otto Robert E · Battle Ground, WABuilt 1974 · S/N 15076117N66556Clausing Howard F · Grafton, WIBuilt 1974 · S/N 15076121N66578Halley Dan R · Avery, TXS/N 15076133N6657GLlw Outlaw Trucking LLC · Iola, TXS/N 15072157N66589Northwest Wings LLC · Hillsboro, ORBuilt 1974 · S/N 15076138N6658FPender Bryan C · Rochester Hills, MIBuilt 1966 · S/N 15063258N66591Bmg Aviation Leasing LLC · Bloomington, INBuilt 1974 · S/N 15076140N66594Gasper Gage · Saint Edward, NEBuilt 1974 · S/N 15076143N66595Fca Flight Center Inc · Fitchburg, MABuilt 1974 · S/N 15076144N66596Odom Aviation Inc · Cabot, ARS/N 15076145N66600Registered aircraftBuilt 1974 · S/N 15076149N66603Bosco Gina · Caldwell, IDBuilt 1978 · S/N 15281662N66611Yeager Jay J · Soldotna, AKBuilt 1974 · S/N 15076153N66614Mann Jeffrey W · Merom, INBuilt 1974 · S/N 15076156N66615Gardner Donald R · Woodbridge, VABuilt 1974 · S/N 15076157N66616Lee Ryan · Soda Springs, CABuilt 1974 · S/N 15076158
Back to AD 2009-10-09 R2