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.

N921MAMoxie Vincent B · Sarver, PABuilt 1969 · S/N 15071284N9222UJdl Services LLC · Centreville, MDBuilt 1976 · S/N 15078172N9225UPrecise Flight LLC · Waukesha, WIBuilt 1976 · S/N 15078175N9226UMcnamara Gavin E W · Rancho Cucamonga, CABuilt 1976 · S/N 15078176N922AKSanderson David C · Fort Davis, TXBuilt 1978 · S/N 15281807N922SWGhulam A Jafferi · South Miami, FLS/N 15076659N9231UCreek William M · Emeryville, CABuilt 1976 · S/N 15078181N9232UWalnut Grove Properties LLC · Eureka, ILBuilt 1976 · S/N 15078182N9233UThorstad Vaughn A · Fargo, NDBuilt 1976 · S/N 15078183N923BRWings Of Grace Ministries Inc · Melbourne, FLBuilt 1967 · S/N 15067181N923SASunrise Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 15283708N9242ULiggett Garrett C · Eminence, MOBuilt 1976 · S/N 15078192N9244UCairo Flying Club Inc · Cairo, ILBuilt 1976 · S/N 15078194N9245UTaylor James R · Murfreesboro, TNS/N 15078195N9246UArtemis Aviation Group LLC · Kalispell, MTBuilt 1976 · S/N 15078196N9251UCarpenter James M · Marion, ARS/N 15078201N9252UHoffman William C · Rostraver Township, PABuilt 1976 · S/N 15078202N9257ULiberty Flyers Inc · Ramsey, MNBuilt 1976 · S/N 15078207N9259UAdirondack Legacy Aircraft LLC · Saratoga Springs, NYBuilt 1976 · S/N 15078209N9260UFlying L Aircraft Inc · Fort Denaud, FLBuilt 1976 · S/N 15078210N9261UOconnor Sean P · Pompano Beach, FLBuilt 1976 · S/N 15078211N9262UNichols Curtis E · Gloucester, VABuilt 1976 · S/N 15078212N9265UEtchell Bruce R · Healdsburg, CABuilt 1976 · S/N 15078215N9266UEgge Danny C · Pelican Rapids, MNBuilt 1976 · S/N 15078216N9267UDavis Andrew P · Leominster, MABuilt 1976 · S/N 15078217N9268UIbrahim Motaz · Goodyear, AZBuilt 1976 · S/N 15078218N9270UYoung Orvel W · Maineville, OHBuilt 1976 · S/N 15078220N9271UWallis Bruce W · Kingwood, TXBuilt 1976 · S/N 15078221N9277UPeters Airway LLC · Pratt, KSBuilt 1976 · S/N 15078227N9281UOtters Heinrich · Fredericksburg, TXBuilt 1976 · S/N 15078231N9282USchur David · Lavernia, TXBuilt 1976 · S/N 15078232N9297UNorthwest Wings LLC · Hillsboro, ORBuilt 1976 · S/N 15078247N92995Yoanna Flight School Inc · Fort Myers, FLBuilt 1981 · S/N 15285372N93002Lcc North LLC · Freehold, NJBuilt 1981 · S/N 15285374N9303UWestover Scott A · Anchorage, AKBuilt 1976 · S/N 15078253N93078Black Cat Aviation LLC · Centennial, COBuilt 1981 · S/N 15285391N93082Schweiger Nathaniel A · Richland, WABuilt 1981 · S/N 15285394N93085Hoffsette Dianna L Trustee · Saint Catharine, MOBuilt 1981 · S/N 15285396N93096Ngumba Andrew N · Long Beach, CABuilt 1981 · S/N 15285399N930JSDolphin Air LLC · Fairbanks, AKBuilt 1975 · S/N 15076752N93116Wichita Area Technical College · Wichita, KSBuilt 1981 · S/N 15285405N93124Pavco Inc · Gig Harbor, WABuilt 1981 · S/N 15285409N93127Dunn W Eric · Lake Wylie, SCBuilt 1981 · S/N 15285411N93142Geoffrion Curt J · Kenai, AKS/N 15285415N93154H & H Aviation Enterprises LLC · Fairfield, OHBuilt 1981 · S/N 15285422N9315UGilbreath Brent · Arlington, TXBuilt 1976 · S/N 15078265N93166Kelly William W · Springfield, ORBuilt 1981 · S/N 15285428N9316URoadrunner Bus LLC · Weston, NEBuilt 1976 · S/N 15078266N9318UWhite David A · Omaha, ARS/N 15078268N93196Registration Pending · Lafayette, LARegistration pendingBuilt 1981 · S/N 15285439
Back to AD 2009-10-09 R2