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.

N2490JSchmitt Rudy · Brookshire, TXBuilt 1966 · S/N 15065590N24920Springett Justin · Boulder, COS/N 15280450N2492JGerke Russell L · Kalispell, MTBuilt 1966 · S/N 15065592N24932Silver Express Co DBA · Miami, FLBuilt 1977 · S/N 15280456N24933Leslie Ethel M · Paonia, COBuilt 1977 · S/N 15280457N24936Scopellite Sebastian · Phoenix, AZS/N 15074859N2493845u Leasing LLC · Beaver Creek, OHBuilt 1977 · S/N 15280459N2493JBrunson Anthony W · Evans, GABuilt 1966 · S/N 15065593N24947Aty Aviation Inc · Watertown, SDS/N 15280464N24950Erbisch Robert · Fruita, COBuilt 1977 · S/N 15280467N24981R&R Aero Services LLC · Eden Prairie, MNBuilt 1977 · S/N 15280490N24986Charlston Michael M · Haleiwa, HIBuilt 1977 · S/N 15280495N24995Stiles Robert K · Lynden, WABuilt 1977 · S/N 15280502N24998Airplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1977 · S/N 15280503N249MCTharp Angela K · Wentzville, MOBuilt 1965 · S/N 15061789N2500QSaydun LLC · Richardson, TXBuilt 1967 · S/N 15066600N25028East Hill Flying Club Inc · Ithaca, NYBuilt 1977 · S/N 15280505N25047Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280514N25053Southwinds Export Inc · Kissimmee, FLNon-citizen corporation, flight hours not reportedS/N 15280517N25057Nino Jose · Kenilworth, NJBuilt 1977 · S/N 15280520N25216Mcfarlane Claude L III · Fitchburg, WIBuilt 1977 · S/N 15280534N25221Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280538N25225Howard Jeff S · Anderson, SCBuilt 1977 · S/N 15280541N25228Laguna Verde Leasing Inc · Wilmington, DES/N 15280543N25233Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280545N25255Flm Aviation LLC · Vernal, UTBuilt 1977 · S/N 15280556N25265My Toys Inc · Spartanburg, SCS/N 15280561N25269Yankaskas Kurt D · Ijamsville, MDBuilt 1977 · S/N 15280563N25271Byrnes Daniel P · Anchorage, AKS/N 15280564N25284Riverside Flight Center Inc · Tulsa, OKBuilt 1977 · S/N 15280572N25286Recreational Enterprises LLC · Sanford, FLS/N 15280573N252MTAero Quest LLC · Olive Branch, MSBuilt 1977 · S/N 15280407N252WCMosier Paul L · Ventura, CABuilt 1979 · S/N 15284145N25301Southern Arkansas University Technical Branch · Camden, ARBuilt 1977 · S/N 15280581N25302Steiner Jason A · Sabetha, KSBuilt 1977 · S/N 15280582N25325Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280596N25332Ewing John L Jr · Yuma, AZBuilt 1977 · S/N 15280600N25351Russell Robert Q · Genoa City, WIBuilt 1977 · S/N 15280609N25357Jameson George T · Auburn, MABuilt 1977 · S/N 15280612N25359Kelly John M · Gastonia, NCBuilt 1977 · S/N 15280614N25362Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280616N25393Oliver Blake H · Talbotton, GAS/N 15280631N25399Hudson Donald L · Camarillo, CABuilt 1977 · S/N 15280633N25408Thompson David J · Pemberton, NJBuilt 1977 · S/N 15280637N25413Dreamair Aviation Inc · Boca Raton, FLBuilt 1977 · S/N 15280641N25416Mikes Aircraft Shop Inc · Corpus Christi, TXBuilt 1977 · S/N 15280643N25426American Aviation Inc · Brooksville, FLBuilt 1977 · S/N 15280651N25430G And M Aircraft Inc · Wheatridge, COBuilt 1977 · S/N 15280654N25467Reynolds Financial Inc · Tyler, TXBuilt 1977 · S/N 15280636N25469Silver Express Co DBA · Miami, FLBuilt 1977 · S/N 15280675
Back to AD 2009-10-09 R2