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.

N757VWHeckert Dale L · Nikiski, AKBuilt 1977 · S/N 15280047N757WPAero Fliers LLC · Kalispell, MTS/N 15280064N757XGJohnson Shawn A · Joliet, MTBuilt 1977 · S/N 15280081N757XHSteinhauser Raymond P · Ashland, OHBuilt 1977 · S/N 15280082N757XWPittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1977 · S/N 15280095N757YARule John D · Nampa, IDS/N 15280099N757YHKnutson Wayne R · Thompson, NDFirst renewal noticeS/N 15280106N757YMDarcy Aviation LLC · Danbury, CTS/N 15280110N757YSJohn Mccaskill Enterprises LLC · Tifton, GABuilt 1977 · S/N 15280115N757YUTechnical Education Services Inc T/A · Virginia Beach, VABuilt 1977 · S/N 15280117N757ZAAdventure Flight Aviation Inc · Springdale, ARBuilt 1977 · S/N 15280123N757ZFProbasco Mitchell L · Floydada, TXS/N 15280128N757ZNJin Jin Aviation LLC · Anchorage, AKBuilt 1977 · S/N 15280135N757ZRBishops' Ltd · Virginia Beach, VABuilt 1977 · S/N 15280138N757ZSDevereaux Mishelle · Raleigh, NCBuilt 1977 · S/N 15280139N757ZTRiya Aviation LLC · Tracy, CABuilt 1977 · S/N 15280140N757ZUUniversity Flying Club Inc · Orono, MES/N 15280141N7581UOse Leroy B · Thief River Falls, MNS/N 15077748N7583UMcgilvray Jerry Alan · Clayton, ALBuilt 1975 · S/N 15077750N7585UMoody Joshua Michael · Springfield, ORBuilt 1975 · S/N 15077752N758PANew Horizons Aviation Inc · Goshen, INBuilt 1978 · S/N 15282932N758YSFly Sky Ads LLC · Manalapan, NJBuilt 1982 · S/N A1521017N758YTMountain Air Flying LLC · Brigham City, UTBuilt 1982 · S/N A1521018N7590UWilson Bobby L · Murray, KYS/N 15077757N7591UBarbour Benjamin · Huntersville, NCBuilt 1975 · S/N 15077758N7592UMiller Collin · Allen, TXBuilt 1975 · S/N 15077759N7595UClavel Carl R · North Platte, NEBuilt 1975 · S/N 15077761N75WCCedar Valley Air LLC · Lehi, UTS/N 15076045N7604UWings Flight Enterprises Inc · Danville, KYBuilt 1975 · S/N 15077766N7607LMeyer Maria S · New Fairfield, CTBuilt 1978 · S/N A1520825N760CAMcculloch Matthew L · Stoutland, MOBuilt 1975 · S/N 15076356N7610AScrap Materials Inc · Huntington, ARS/N A1520738N7616UShepard Gregory W · Fort Myers, FLBuilt 1975 · S/N 15077770N7617URikki Air LLC · Clarksville, TXBuilt 1975 · S/N 15077771N761ESCronsell Kenneth L · Hampshire, ILBuilt 1980 · S/N A1520947N761FGWilliams Glenn D · Columbus, GABuilt 1980 · S/N A1520949N761GGChocks Away Aviaton LLC · Redmond, ORBuilt 1980 · S/N A1520951N761MAWilliams Charlie · Trenton, SCS/N 15065219N761UAFirst Wings LLC · Sayre, PAS/N A1520986N761YEUnique Educational Experiences Inc · Signal Hill, CABuilt 1981 · S/N A1520997N762JSSayers James B · Edison, OHBuilt 1981 · S/N A1520970N762MAGiovannetti Peter C · Fond Du Lac, WIBuilt 1966 · S/N 15065187N763PAComputer Services Inc · Yukon, OKBuilt 1974 · S/N 15075618N763SASunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15283073N7649GSipes Aircraft LLC · Livingston, TXS/N 15074710N7649URey Henry R · Fresh Meadows, NYBuilt 1975 · S/N 15077775N764CPApmg Aircraft Management LLC · Las Vegas, NVBuilt 1965 · S/N 15061758N7655USitta Donald C · Farmington, NMBuilt 1976 · S/N 15077781N7657GDodd Brian G · Mount Vernon, SDBuilt 1973 · S/N 15074711N7658URegistration Pending · Oregon City, ORRegistration pendingBuilt 1976 · S/N 15077784
Back to AD 2009-10-09 R2