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.

N50915Donato Robert J · East Berlin, PABuilt 1968 · S/N 15069639N50920Campbell James R · Temple City, CABuilt 1968 · S/N 15069643N50921Hernandez Jesus C · Elberton, GABuilt 1968 · S/N 15069644N50936Qualitair LLC Trustee · MichelstadtS/N 15069656N5093QRiya Aviation LLC · Tracy, CABuilt 1981 · S/N 15285073N50948Salomonsson Mats E · Hayward, CABuilt 1968 · S/N 15069668N5094LGorge Winds Aviation Inc · Fairview, ORBuilt 1980 · S/N 15284260N50957Anklam Eugene E · Claremore, OKS/N 15069673N5095PGyrfalcon Air Holdings LLC · Boise, IDS/N 15284875N50960Ortiz Tech LLC · Doral, FLBuilt 1968 · S/N 15069675N5096LPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1980 · S/N 15284262N50984Roberts Wayne A Jr · Juneau, AKBuilt 1968 · S/N 15069687N50987Berg James O · Dunseith, NDBuilt 1968 · S/N 15069690N50989Und Aerospace Foundation · Grand Forks, NDBuilt 1975 · S/N 15077226N50990Fielden Virgil A · Fairfield, TXBuilt 1968 · S/N 15069693N50992Flom Tyler M · Evans, GABuilt 1968 · S/N 15069695N50994Plane Junkies LLC · Dover, DES/N 15069696N50996Burke John E · Spring, TXBuilt 1968 · S/N 15069698N50JXDls Holdings Inc · Arlington, TXBuilt 1973 · S/N 15074642N50PTJackson Michael W · Bedford, TXBuilt 1968 · S/N 15069220N50TLSmith Lynn D · Roosevelt, UTBuilt 1970 · S/N A1500203N50XFHdw Florida Helicopters Inc · Pompano Beach, FLS/N 15074345N51000Jet-I Aviation LLC · Palm City, FLS/N 15069700N51009Bowers Shane A · Bixby, OKBuilt 1968 · S/N 15069706N5100QTulsa Technology Center School District 18 · Tulsa, OKBuilt 1981 · S/N 15285075N5101HAberdeen Flying Service · Aberkeen, SDBuilt 1979 · S/N 15284061N51029Cywan Alex M · Sherman Oaks, CABuilt 1968 · S/N 15069716N51040Pruitt Benny G · Reidsville, NCBuilt 1968 · S/N 15069721N51046Weeks Thomas W · Ypsilanti, MIBuilt 1968 · S/N 15069726N51047Huls Timothy J · Stevensville, MTBuilt 1968 · S/N 15069727N51048Heermance Timothy Jr · West Palm Beach, FLBuilt 1968 · S/N 15069728N51052Smithard Austin · Peachtree, GAS/N 15069730N51059Donadio Gerard J · Ronkonkoma, NYS/N 15069736N5105MAscend Aviation LLC · Bountiful, UTBuilt 1980 · S/N 15284499N5105PJet & Rotor Aviation LLC · Sacramento, CABuilt 1981 · S/N 15284877N51060Elmore Eric T · Colorado Springs, COS/N 15069737N51068Hodges Michael D · Glenpool, OKBuilt 1968 · S/N 15069743N51069Sport Flyer LLC · Jackson, WYBuilt 1968 · S/N 15069744N5106BBabcock Lori A · Salina, KSBuilt 1979 · S/N 15283747N51074Donner John R · Clara City, MNBuilt 1968 · S/N 15069747N5107BWest Valley Flying Club · Palo Alto, CABuilt 1979 · S/N 15283748N51082Fremont Aviation Inc · Fremont, NES/N 15069750N51088Otterson Val Stanford · Willows, CABuilt 1968 · S/N 15069756N5108LHellix LLC · Charlotte, NCS/N 15284266N5109APace Glen M · Columbia, MSS/N 15069450N5109BOverlander Aviation LLC · Palo Alto, CABuilt 1979 · S/N 15283750N510SUOhio State University · Columbus, OHBuilt 1973 · S/N 15074297N51102Tidwell Brian D · Portland, ORBuilt 1968 · S/N 15069766N51103Malachi Israel P · Superior, WIBuilt 1968 · S/N 15069767N51105Du Bois Aviation Inc · Chino, CAS/N 15069769
Back to AD 2009-10-09 R2