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.

N2963SDougherty Paul · Bethel, PABuilt 1967 · S/N 15066863N2964SRichardson David M · Dwight, ILBuilt 1967 · S/N 15066864N2964VPlane Awesome LLC · Plymouth, MAS/N 15076335N2966VBode Aviation Inc · Albuquerque, NMBuilt 1974 · S/N 15076336N2967SJordan Jason A · Portland, MEBuilt 1967 · S/N 15066867N2968SVoyles Robert L · Seymour, TNBuilt 1967 · S/N 15066868N2970JFlorida State College At Jacksonville · Jacksonville, FLBuilt 1966 · S/N 15065770N2970SDouble Circle LLC · Bosque Farms, NMBuilt 1967 · S/N 15066870N2972JN2972j LLC · Nacogdoches, TXBuilt 1966 · S/N 15065772N2972SMaxwell Lance C · Saint Charles, ILBuilt 1967 · S/N 15066872N2973JHoyos Nicholas · Weston, FLBuilt 1966 · S/N 15065773N2974ULeibach Frederick A · Peoria, ILBuilt 1965 · S/N 15062332N2976JHanson Larry R · Buffalo, WYBuilt 1966 · S/N 15065776N2976SSapp Jarrell · Sale City, GAS/N 15066876N2977JBandy Suzanne M · Newport, ORS/N 15065777N2977VKnott Brody · Camarillo, CABuilt 1974 · S/N 15076340N2978SRoach David · Modena, NYS/N 15066878N2979JStygar Richard M · Coal City, ILBuilt 1966 · S/N 15065779N2980JOrsak Eddie J · Seymour, TXBuilt 1966 · S/N 15065780N2982JTijman Esteban M · Potomac, MDBuilt 1966 · S/N 15065782N2982SHerzog Daniel L · Clinton, MIS/N 15066882N2984JBell Edward A · Richfield, OHBuilt 1966 · S/N 15065784N2985JScott Jason Eton · Seattle, WABuilt 1966 · S/N 15065785N2986JWylam Thomas S · Ocala, FLBuilt 1966 · S/N 15065786N2986SHouglan Norman L · Shepherdsville, KYBuilt 1967 · S/N 15066886N2988JRegistration Pending · Asotin, WARegistration pendingBuilt 1966 · S/N 15065788N2989JWright Brandon C · Cave City, KYS/N 15065789N2990JHale Randall C · Bloomburg, TXS/N 15065790N2990SAndresen Paul S · Chandler, AZS/N 15066890N2991SVanbrocklin Valerie A · Anchorage, AKBuilt 1967 · S/N 15066891N2992SN2992s LLC · Bristol, VTBuilt 1967 · S/N 15066892N2993SCintron Jaime · Lake City, FLS/N 15066893N2995SWillard Kevin C · Bartlett, NEBuilt 1967 · S/N 15066895N2996JDziadaszek Daniel J · Yemassee, SCBuilt 1966 · S/N 15065796N2996SKingdom Air Corp · Sutton, AKS/N 15066896N2999SZheng Zheng · Walnut, CABuilt 1967 · S/N 15066899N29NDDamstetter Katherine M · Hudson, FLS/N 15066888N2BFMs Aero Inc · Lakeville, OHBuilt 1968 · S/N 15068499N2MSLemmon William Michael · N Richland Hills, TXBuilt 1978 · S/N 152-82011N2TAMontgomery Keith L · Florence, ALBuilt 1972 · S/N 15073811N3003XAero Flyers LLC · Stephenson, VABuilt 1966 · S/N 15064403N3005SSpennato Peter Jr · Rolling Hills, CABuilt 1967 · S/N 15066905N3005XOso Air LLC · Missoula, MTBuilt 1966 · S/N 15064405N3006SGrice Warren A · Marshall, ARBuilt 1967 · S/N 15066906N3006XRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1966 · S/N 15064406N3007XKelley Keith B · Forney, TXBuilt 1966 · S/N 15064407N3008XAdams Harold L · Beaver, OHBuilt 1966 · S/N 15064408N3009SRegistration Pending · Arlington, TXRegistration pendingBuilt 1967 · S/N 15066909N3009XWarren Jeremy I · Horse Cave, KYBuilt 1966 · S/N 15064409N300YWShell John E · Waverly, OHBuilt 1966 · S/N 15062936
Back to AD 2009-10-09 R2