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.

N18522Carr Scott · Bells, TXBuilt 1972 · S/N 15073911N18524Alpha International Aircraft Inc · Lewes, DES/N 15073913N18527Bundy Richard S · Little Egg Harbor, NJBuilt 1972 · S/N 15073916N18531National Test Pilot School · Mojave, CABuilt 1972 · S/N 15073920N18533Booth Donald V · Denison, TXS/N 15073922N18534Rupert Dinah J · New Plymouth, OHFirst renewal noticeBuilt 1972 · S/N 15073923N18537Kirsch Richard D · Lisbon, NDBuilt 1972 · S/N 15073925N18540Fisher Tracey R · Glenwood, IAS/N 15073928N18546O'Sita Tade · Burnsville, MNFirst renewal noticeBuilt 1972 · S/N 15073934N18552Malecha James L Trustee · Wilmot, NHBuilt 1972 · S/N 15073937N18554Lavelle Jonathan A · Berrien Springs, MIBuilt 1972 · S/N 15073938N18558Gunderson Robert B · League City, TXBuilt 1972 · S/N 15073941N18565Hughes Danny R · Hickory, NCBuilt 1972 · S/N 15073946N18567Barros Da Silva Norton · Tyler, TXBuilt 1972 · S/N 15073948N18568Green Tom H · Vega, TXBuilt 1972 · S/N 15073949N18569Doyle Harley M · O Brien, FLBuilt 1972 · S/N 15073950N18572Stofka Joseph M · Erie, MIBuilt 1972 · S/N 15073952N18574Reed Philip D · Millsboro, DEBuilt 1972 · S/N 15073954N18578Nauerth John III · Lakefield, MNBuilt 1972 · S/N 15073956N18579Beck Roger M Trustee · Goode, VABuilt 1972 · S/N 15073957N18580Kirk Bryan · Las Vegas, NVBuilt 1972 · S/N 15073958N18582Voigts Bruce M · Clarion, IABuilt 1972 · S/N 15073960N18583Niles Donald W · Wadena, MNBuilt 1972 · S/N 15073961N18584Murphey Julian Ryan · Knoxville, TNS/N 15073962N18586Flyit LLC · Camas, WABuilt 1972 · S/N 15073964N18587Payne Frederick B · Fayetteville, GABuilt 1972 · S/N 15073965N18590Williams Michael · Williston, FLBuilt 1972 · S/N 15073968N18594Robinson Ronald W · Saint Joseph, MIBuilt 1972 · S/N 15073970N18596Baxter Wiley · Glennville, GABuilt 1972 · S/N 15073972N18597Kiser Joshua Alan · Dry Ridge, KYS/N 15073973N18598Gudgel Aviation · Lemoore, CABuilt 1972 · S/N 15073974N185SEJensen Aviation Inc · Zephyrhills, FLBuilt 1978 · S/N 15282935N185SRHillbilly Holler LLC · Missoula, MTBuilt 1979 · S/N 15283215N185WTPenley Robert G · Corinth, TXBuilt 1972 · S/N 15073919N18612Missoula Fliers LLC · Milltown, MTBuilt 1972 · S/N 15073987N18618Hammons Bryan S · Stephenville, TXBuilt 1972 · S/N 15073991N18623Fleischmann Fred · Racine, WIBuilt 1972 · S/N 15073994N18627Oberhansly Lucas C · Roy, WABuilt 1972 · S/N 15073998N18628Paul William A · Windfall, INBuilt 1972 · S/N 15073999N18630Gaddy Tyler Quintin · Advance, NCBuilt 1972 · S/N 15074000N18634Bagge William J · East Longmeadow, MABuilt 1972 · S/N 15074004N18637Vincent Addison J · Waynesburg, OHBuilt 1972 · S/N 15074006N18640Smith David W · Elgin, SCBuilt 1972 · S/N 15074008N18645Sorenson Mark A · Senoia, GAS/N 15074011N18649Dixon Robert D · Derry, PAFirst renewal noticeBuilt 1972 · S/N 15074015N18656Larsen Steve · Colton, ORBuilt 1972 · S/N 15074019N18663Van Dyke John · Hopkins, MIBuilt 1973 · S/N 15074025N18674Vandervegt Nathan J · Juneau, AKBuilt 1972 · S/N 15074034N18678Laviolette Stephen O · Dallas, TXBuilt 1972 · S/N 15074037N18686Duvoisin Tom Jr · Powell, TNBuilt 1972 · S/N 15074041
Back to AD 2009-10-09 R2