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.

N6131GCragg Gordon E · Georgetown, TXBuilt 1969 · S/N 15071631N61321Gerdes Brian K · Los Alamitos, CAS/N 15070963N61324Wills Evan J · Lynnwood, WABuilt 1969 · S/N 15070964N61325Zetir Mohamad · Oviedo, FLBuilt 1969 · S/N 15070965N61329Girls Love To Fly Inc · Roseville, CABuilt 1969 · S/N 15070969N6132QHeavy Metal Air LLC · Farmingdale, NYS/N 15285156N61333Gustafson Michael J · Minnetonka, MNBuilt 1969 · S/N 15070972N61336Evans David C · Thousand Oaks, CABuilt 1969 · S/N 15070973N61338Flyit LLC · Camas, WABuilt 1969 · S/N 15070975N6133KSturguess James K · Boonville, MOS/N 15077542N61345Carlson Brent A · Shelley, IDS/N 15070980N6134KMackenzie Stuart · Pearland, TXS/N 15077543N6134LEuro 2000 Inc · Merritt Island, FLS/N 15284362N61354New Vision Aviation · Fresno, CABuilt 1969 · S/N 15070985N6135FJr Imaging Logistics Inc · Pasco, WABuilt 1973 · S/N A1500423N6135QLake Effect Aviation LLC · Java Center, NYBuilt 1981 · S/N 15285159N61363Hulbert Stephen R · Fort Ransom, NDBuilt 1969 · S/N 15070989N61365Plane Progress LLC · Waterloo, IABuilt 1969 · S/N 15070990N6137GPiersol Benjamin T · Honey Brook, PABuilt 1969 · S/N 15071637N6138GStrange Keith · Lincoln, MEBuilt 1969 · S/N 15071638N6139KKuykendall Justin R · Petaluma, CAFirst renewal noticeBuilt 1975 · S/N 15077547N6139MKelly David M · Issaquah, WAFirst renewal noticeBuilt 1980 · S/N 15284630N6140FFluno John I · San Rafael, CAS/N A1500425N6140GSmoketown Flight Center LLC · Smoketown, PABuilt 1969 · S/N 15071640N6142KCreamer Ryan Patrick · Tower Hill, ILBuilt 1975 · S/N 15077550N6143GSale Reported · Brodhead, WISale reportedBuilt 1969 · S/N 15071643N6143QSt Onge Andre E · Hooksett, NHBuilt 1981 · S/N 15285166N6144GHoke Christopher R · Kernersville, NCS/N 15071644N6144LArtz Agri Sales LLC · Westhope, NDBuilt 1980 · S/N 15284364N6145FAlpha Bravo Aviation LLC · Trophy Club, TXBuilt 1973 · S/N A1500426N6146FHeppner Sebastian · Fishers, INS/N A1500427N6146QWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 1981 · S/N 15285169N6149QGreen Airports Development Corp · Kemah, TXBuilt 1981 · S/N 15285172N614BGNorth Star Aviation Inc · Mankato, MNBuilt 1980 · S/N 15284205N6150GStockton Raymond L · Pearl City, HIBuilt 1969 · S/N 15071650N6150MJprg Aviation Inc DBA · Orlando, FLBuilt 1980 · S/N 15284631N6151KRomano Aviation LLC · Barrington, RIBuilt 1975 · S/N 15077555N6154GGrinnell Matthew J · Auburndale, FLBuilt 1969 · S/N 15071654N6154QViman LLC · Bear, DEBuilt 1981 · S/N 15285174N6155FHalladay Roy · Erie, COBuilt 1973 · S/N A1500432N6155GChin Benny C · Chandler, AZS/N 15071655N6155QFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1981 · S/N 15285175N6157FLa Placa Peter · Lake Havasu City, AZBuilt 1973 · S/N A1500434N6161GGough James L · Hesston, KSBuilt 1969 · S/N 15071661N6161KSmith William F · Hindsville, ARBuilt 1975 · S/N 15077562N6163KJennings Steven W · Austin, TXS/N 15077563N6165GPartida Carlos · Delray Beach, FLBuilt 1969 · S/N 15071665N6167FJohnson Susan J · Chelan, WABuilt 1973 · S/N A1500437N6169GKingdom Air Corps · Sutton, AKBuilt 1969 · S/N 15071669N6171GMission Flight Academy · Yucaipa, CAS/N 15071671
Back to AD 2009-10-09 R2