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.

N8772SMccormick Joel S · Elmwood, ILBuilt 1965 · S/N 15062072N8773GWhite Jules W · Wichita, KSBuilt 1966 · S/N 15062873N8778UWright Penny L · San Francisco, CAS/N 15077986N8779GEga Aero Specialty Services LLC · Beaufort, SCBuilt 1966 · S/N 15062879N877ATAir One Inc · Valparaiso, INBuilt 1966 · S/N 15063724N8780UReeves Gary A · Lorimor, IABuilt 1976 · S/N 15077988N8784UWilson Jacob T · Loma Linda, CABuilt 1976 · S/N 15077991N8785GPate Robert J · Hilltop Lakes, TXBuilt 1966 · S/N 15062885N8785USchoenling Joseph S · Cincinnati, OHBuilt 1976 · S/N 15077992N8786GKellum Roman Micah · Alexander City, ALS/N 15062886N8786SJae Grace Elizabeth · Madison, ALBuilt 1966 · S/N 15062086N8788GWagenaar Diane D · Frankston, TXBuilt 1966 · S/N 15062888N8789ULangley Bryan T · Springfield, OHBuilt 1976 · S/N 15077993N8790UPonte Ralph M DBA · Grass Valley, CABuilt 1976 · S/N 15077994N8792UBenair LLC · Bonita Springs, FLBuilt 1976 · S/N 15077996N8794SUS Flight Academy International Inc DBA · Post, TXBuilt 1965 · S/N 15062094N8794UMock Joseph R · Huntsville, TXBuilt 1976 · S/N 15077997N8795GDesousa Raphael · Fremont, CABuilt 1966 · S/N 15062895N8795SHuffman Jacob M III · Burleson, TXBuilt 1965 · S/N 15062095N8796GSouthwest Texas Junior College · Uvalde, TXBuilt 1966 · S/N 15062896N8796SSkylane Of Willmar LLC · Willmar, MNBuilt 1965 · S/N 15062096N8797USowers Harry D · S Bloomingville, OHBuilt 1976 · S/N 15077999N8798GMclemore Cecil E · Woodland, CAS/N 15062898N8798UMimbach Mitchell J · Rice, MNBuilt 1976 · S/N 15078000N8799SStroemsvik Kristian · Strasburg, VAS/N 15062099N87YThompson Jeff D · Tonasket, WABuilt 1975 · S/N 15075800N880Sanders Trent Trustee · La Canada Flt, CABuilt 1966 · S/N 15063567N8800SMiedema Todd · Red Rock, TXBuilt 1965 · S/N 15062100N8802SVan De Weert Steven G · Littleton, COBuilt 1965 · S/N 15062102N8804GN8804g LLC · Edgefield, SCS/N 15062904N8805GMazor Chris · Van Buren Twp, MIS/N 15062905N8805SBatt Timothy D · Mc Grath, AKBuilt 1965 · S/N 15062105N8807GHague Ryder S · Bradfordsville, KYS/N 15062907N8807UHarkins Robert W · Arnold, CAS/N 15078002N8808SReber Scott D · Newcastle, UTBuilt 1965 · S/N 15062108N8809SJednacz Scott T · Bixby, OKFirst renewal noticeBuilt 1965 · S/N 15062109N880PMTimeless Flight LLC · Spanaway, WABuilt 1966 · S/N 15065825N8810GSobers Dolton D A Jr · Caguas, PRBuilt 1966 · S/N 15062910N8812SAnderson Benjamin J · Mondovi, WIBuilt 1965 · S/N 15062112N8817SRomeo Tango Aircraft Holding LLC · Merritt Island, FLBuilt 1965 · S/N 15062117N8819GGipson Aviation LLC · Winchester, TNBuilt 1966 · S/N 15062919N8819SSmith Cory M · Naples, FLBuilt 1965 · S/N 15062119N8820GMcdavid Bourke D Jr · Crestview, FLBuilt 1966 · S/N 15062920N8822SRegistration Pending · Mishawaka, INRegistration pending, canceledBuilt 1965 · S/N 15062122N8824GHarper Brian · Lake Jackson, TXBuilt 1966 · S/N 15062924N8826GAlexander Jon D · Mohall, NDBuilt 1966 · S/N 15062926N8830GSmokovitz Joseph M · Tecumseh, MIBuilt 1966 · S/N 15062930N8832SSlad George W · Albuquerque, NMBuilt 1965 · S/N 15062132N8834SNewlin Thomas R · Montezuma, INBuilt 1965 · S/N 15062134N8835GNelson Joel B · Alliance, OHBuilt 1966 · S/N 15062935
Back to AD 2009-10-09 R2