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.

N3010VMurillo George A · Fremont, CAS/N 15076349N3012SMarshe Aviation LLC · Upland, CABuilt 1967 · S/N 15066912N3012XByrne Matthew A · West Allis, WIBuilt 1966 · S/N 15064412N3013SRunge Robert H · Sidney, NEBuilt 1967 · S/N 15066913N3013XGreeneway Charles G · Armour, SDBuilt 1966 · S/N 15064413N3016SBartholomew Dana C · Madison, WIBuilt 1967 · S/N 15066916N3017XMunson Timothy G · Mendota, ILBuilt 1966 · S/N 15064417N3018XWard David J · Garden Valley, IDBuilt 1966 · S/N 15064418N3019XSkyy King LLC · Helena, MTBuilt 1966 · S/N 15064419N301GWCollege Of Missionary Aviation Inc · Keystone Heights, FLBuilt 1969 · S/N 15071678N301PFLahm David K · Cozad, NEBuilt 1975 · S/N 15076830N3020XLima 2 Aviation Of Mississippi LLC · Bogue Chitto, MSBuilt 1966 · S/N 15064420N3021SCollett Danny W · Stewart, TNBuilt 1967 · S/N 15066921N3021XMay'S Welding Service Inc · Cotulla, TXS/N 15064421N3022SMcnulty Bobby J · Luling, LABuilt 1967 · S/N 15066922N3022VRetroair Restoration LLC · Big Lake, AKBuilt 1974 · S/N 15076354N3022XCintim LLC · Carrabelle, FLS/N 15064422N3023SSynnes Dale C · Santa Paula, CABuilt 1967 · S/N 15066923N3024XDavis James M · Tuscaloosa, ALBuilt 1966 · S/N 15064424N3025SHummer Bryant C · Garden Plain, KSBuilt 1967 · S/N 15066925N3026SSolewin Kimberly M · Christoval, TXBuilt 1967 · S/N 15066926N3026VNew Mexico Flying Eagle Inc DBA · Tucson, AZS/N 15076355N3027XSchneider Benjamin J · Wheeling, WVBuilt 1966 · S/N 15064427N3028VChildress Sam · Weatherford, TXBuilt 1974 · S/N 15076357N3028XFicken Jerome L · Cedar Hill, MOBuilt 1966 · S/N 15064428N3029SBlawusch Richard K · Waterloo, WIBuilt 1967 · S/N 15066929N3029VFlyt LLC · Madison, MSS/N 15076358N3029XRegistered aircraftS/N 15064429N3030VSanders Flight Training Center Inc · Jasper, ALBuilt 1974 · S/N 15076359N3032XMagaruh George M · Roscoe, ILBuilt 1966 · S/N 15064432N3033SWelch Cara · Concrete, WABuilt 1967 · S/N 15066933N3034SMore Development LLC · Tucson, AZBuilt 1967 · S/N 15066934N3034XChandler Jerry D · Pilot Mountain, NCBuilt 1966 · S/N 15064434N3035X29 Soaring Club Inc · Twentynine Palms, CABuilt 1966 · S/N 15064435N30384Knutson Wayne R · Thompson, NDS/N 15064473N3038SAbove All Aviation · Goleta, CABuilt 1967 · S/N 15066938N3039VMiller Zachary L · Roseau, MNBuilt 1974 · S/N 15076364N3040SPearson Wayne L · Fayetteville, ARS/N 15066940N3040VFlight Deck Air And Sea LLC · West Palm Beach, FLS/N 15076365N3041XSky Partners LLC · Sylacauga, ALBuilt 1966 · S/N 15064441N3043XVaughan John T · Safety Harbor, FLBuilt 1966 · S/N 15064443N3045VBuck Quincy M · Lakeville, MNBuilt 1974 · S/N 15076367N3046SWhite William E · Watkinsville, GABuilt 1967 · S/N 15066946N3047SBarrons Aviation Services LLC · Henderson, NVBuilt 1967 · S/N 15066947N3047XSmith Richard D DBA · Williamstown, OHBuilt 1966 · S/N 15064447N3048SFlight Expo Inc · Princeton, MNS/N 15066948N3048XVisconti Phillip M · Hominy, OKBuilt 1966 · S/N 15064448N3049SGenthner Scott A · Milo, MEBuilt 1967 · S/N 15066949N3049VCraig Dennis M · Yukon, OKBuilt 1974 · S/N 15076369N304DWBrown Rodney D · Foxworth, MSS/N 15285462
Back to AD 2009-10-09 R2