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.

N63132Ha Peter · Eastvale, CABuilt 1975 · S/N 15077124N63138Sport Flyer Service LLC · Katy, TXBuilt 1975 · S/N 15077130N63149Aviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1975 · S/N 15077138N6314GKing William E · Simpsonville, SCBuilt 1970 · S/N 15071814N6314LCzed Investments · Westlake, LABuilt 1980 · S/N 15284385N63154Burleson James G · Grand Prairie, TXBuilt 1975 · S/N 15077142N63155Morten David J · Larimore, NDS/N 15077143N63157Tadres Abanob Y · Antioch, TNBuilt 1975 · S/N 15077145N6315SDelta Delta Aviation Group Inc · New Castle, DEBuilt 1967 · S/N 15067115N63165Eagle Eye Aviation LLC · Mccomb, MSBuilt 1975 · S/N 15077150N63169Spinola Hernandes M · Homestead, FLBuilt 1975 · S/N 15077153N6316BSouthwinds Export Inc · Kissimmee, FLS/N 15283918N6316GChurch Aviation LLC · Christmas Valley, ORFirst renewal noticeS/N 15071816N6316SGlobal Navigator LLC · Anacortes, WABuilt 1967 · S/N 15067116N63179Fetch Carl Jr · Monongahela, PABuilt 1975 · S/N 15077157N6317QSouthwinds Export Inc · Kissimmee, FLS/N 15285230N63180Hall Thomas E · Sylvia, KSBuilt 1975 · S/N 15077158N63181Wild Blue Flight LLC · Ellensburg, WABuilt 1975 · S/N 15077159N63186Branche Mitchell J · Winter Haven, FLBuilt 1975 · S/N 15077164N63197Deangelis Kristopher M · Las Vegas, NVBuilt 1975 · S/N 15077166N63198White Hayden · Lees Summit, MOBuilt 1975 · S/N 15077167N63199Winfred & Waters LLC · Georgetown, TXBuilt 1975 · S/N 15077168N6319KStemmer Kenneth Edward · Palm Desert, CABuilt 1975 · S/N 15077641N631EHHuddleston Edward L · Oaktown, INBuilt 1966 · S/N 15063361N631PAPetaluma Pilot Training Center · Petaluma, CABuilt 1977 · S/N 15280835N63205Bagwell Robert B · Sequim, WABuilt 1975 · S/N 15077173N63207Two Star Maritime LLC · Fremont, CABuilt 1975 · S/N 15077175N6320GBurks Michael S · Shoshone, IDBuilt 1970 · S/N 15071820N63210Johnson Mark L · Bend, ORBuilt 1975 · S/N 15077177N63211Prestige Worldwide Charters LLC · Edgartown, MABuilt 1975 · S/N 15077178N63214Brady William Berte · Venice, FLS/N 15077181N63219Cresap Dale A · Idaho Falls, IDS/N 15077185N6321GFurlong Kelly · Athens, ALBuilt 1970 · S/N 15071821N6321KBrookby John M · Grand Prairie, TXBuilt 1975 · S/N 15077642N6321MCalifornia In Nice Inc · San Jose, CABuilt 1980 · S/N 15284671N6321PXin Han Aviation LLC · Atwater, CABuilt 1981 · S/N 15284999N6321SStoker Dana R Trustee · Tucson, AZBuilt 1967 · S/N 15067121N63220Ronchini Denis · Haverhill, MABuilt 1975 · S/N 15077186N63221Ruebush Joshua K · Eaton, OHBuilt 1975 · S/N 15077187N63231Stafford Anthony T · Collierville, TNS/N 15077189N63233Gill Charles D · Baton Rouge, LABuilt 1975 · S/N 15077191N63234Guerrero Erwin F · South Bend, INBuilt 1975 · S/N 15077192N63237Biemer Alexander · Spring Branch, TXBuilt 1975 · S/N 15077195N63244Bacus Brent · Indianapolis, INS/N 15077199N63246Musser John R · Freeport, ILBuilt 1975 · S/N 15077200N63248Lewis Luther Daniel · New Bern, NCBuilt 1975 · S/N 15077202N6324GArmstrong Paul · San Francisco, CAS/N 15071824N6324KRegistration Pending · Princeton, NJRegistration pendingBuilt 1975 · S/N 15077643N6324SKleis Richard L · Zwingle, IABuilt 1967 · S/N 15067124N63252Bork Michael F · Kalamazoo, MIBuilt 1975 · S/N 15077205
Back to AD 2009-10-09 R2