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.

N724MCSutton Aircraft Salvage LLC · Palmer, AKBuilt 1970 · S/N 15072198N7254SNickels Robert D · Fayetteville, TNBuilt 1967 · S/N 15067954N72579Allee Mark J · Gillette, WYBuilt 1967 · S/N 15067593N7257SFidalgo Flyers LLC · Anacortes, WABuilt 1967 · S/N 15067957N7258SBusiness As Usual LLC · Spartanburg, SCBuilt 1967 · S/N 15067958N7259SSchafer Louis L · Murfreesboro, TNBuilt 1967 · S/N 15067959N725RBBatesole William D Trustee · Walpole, NHBuilt 1968 · S/N 15068309N7271SWalker Kevin · Stillwater, OKBuilt 1967 · S/N 15067971N7272SRegistered aircraftBuilt 1967 · S/N 15067972N7273SFerguson Jeffrey Woods · San Antonio, TXBuilt 1967 · S/N 15067973N7274GFlyit LLC · Washougal, WABuilt 1973 · S/N 15074632N7276SMorgan Michael · Wichita, KSBuilt 1967 · S/N 15067976N7277SMarkland Benjamin Harrison · Lehigh Acres, FLBuilt 1967 · S/N 15067977N7279GMartin Rick · Rindge, NHBuilt 1973 · S/N 15074633N7279SLee Peter Joohak · Irvine, CABuilt 1967 · S/N 15067979N727BSHorvath Andrew J · Winnsboro, SCBuilt 1966 · S/N 15064667N727HMPatterson Casey Paul · Kinston, ALS/N 15066715N7282GDurley Randal W · Talladega, ALFirst renewal noticeBuilt 1973 · S/N 15074634N7282SDavis Patrick I · Acampo, CABuilt 1967 · S/N 15067982N7283GPetersen Conrad H · Kenmare, NDBuilt 1973 · S/N 15074635N7283SMiller Bambi · Lee, NHS/N 15067983N7285SHenry Mark A · Dickinson, TXBuilt 1967 · S/N 15067985N7286GRegistered aircraftBuilt 1973 · S/N 15074636N7286SMaychezak Lana R · Sentinel Butte, NDBuilt 1967 · S/N 15067986N7289SHancock Deborah M · Hayes, VABuilt 1967 · S/N 15067989N728LCHeath Richard · Raymondville, TXBuilt 1974 · S/N 15075773N7293SGraham John T · Phoenix, AZBuilt 1967 · S/N 15067993N7295SSpeedbird Ventures LLC · Driftwood, TXS/N 15067995N7297GBraun Ralph H · Moreno Valley, CAS/N 15074638N7297SBukkila Joan E · Savage, MNBuilt 1967 · S/N 15067997N72CPGrant Henry R H · Ocracoke, NCBuilt 1973 · S/N 15075051N7303GGolden Greg J · Thurman, IABuilt 1973 · S/N 15074640N7305LHill Stephen C · Fort Collins, COBuilt 1978 · S/N A1520780N7312GKlitzke Lucanus E · La Plata, NMBuilt 1973 · S/N 15074644N7313GBend-Over Hill Aviation LLC · Dover, DEBuilt 1973 · S/N 15074645N7315ATiny Sparrow Aviation LLC · Irvine, CAS/N A1500709N7319AHart George · Yuba City, CAS/N A1500712N7321BAdvanced Aviation School LLC · Venice, FLBuilt 1977 · S/N A1520743N7322ABaas Keith L · Alto, MIBuilt 1976 · S/N A1500715N7322GHolt Thomas H · Griffin, GAS/N 15074647N7327ACordova Coast Inc · King Salmon, AKBuilt 1976 · S/N A1500716N7329ASargent Evan · Camas, WABuilt 1976 · S/N A1500717N7330BLogan Richard M · St Louis Park, MNBuilt 1977 · S/N A1520746N7335APomeroy Keith R · Port Saint Lucie, FLS/N A1500721N7336BWild Robert · Woodbury, NJBuilt 1977 · S/N A1520750N7340BThaut Lance A · Fullerton, CABuilt 1977 · S/N A1520752N7340LAzure 01 LLC · Canton, NYBuilt 1978 · S/N A1520792N7343ACheek Kenneth W · Yadkinville, NCBuilt 1977 · S/N A1500722N7348BPatry Andrew · El Mirage, AZBuilt 1977 · S/N A1520753N7349BWilliams Kiplin S · Midland, NCBuilt 1977 · S/N A1520754
Back to AD 2009-10-09 R2