OpenAirDocs.org
AD 2009-13-06 R1

Registered aircraft · 2,130

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-13-06-R1')
    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-13-06-R1')
  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.

N7294PMcnamara Pa · Far Hills, NJBuilt 1978 · S/N 27-7854072N72JJCatton Consulting LLC · Fairfax Station, VABuilt 1980 · S/N 31T-8004048N72LKN72lk Holding Company LLC · Coral Gables, FLS/N 31-8352004N730MCCpc2 Aviation LLC · Hoover, ALBuilt 1965 · S/N 27-3097N730PTTwin Otter International Ltd · Las Vegas, NVBuilt 1977 · S/N 31T-7720008N731PBBeaver Creek Aviation LLC · Perry, IABuilt 1980 · S/N 31T8166001N7331LStibolt Paul E · New Richmond, WIBuilt 1974 · S/N 31P-7400210N7344LRhs Consulting Ltd LLC · Reno, NVBuilt 1974 · S/N 31P-7400229N735QStuart Aviation Holdings LLC · Stuart, FLBuilt 1978 · S/N 31-7812089N737WKInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 31-7812079N73BGRw Air Services Inc · Hatfield, PAS/N 31T-8004027N73CZBm Air LLC · Anaconda, MTBuilt 1980 · S/N 31-8052177N73LKMoore David E · Stuart, FLBuilt 1979 · S/N 31-7912123N73RTRegent Trust Corp Trustee · Wichita, KSBuilt 1982 · S/N 31-8252023N73VPyle Dana · Naples, FLBuilt 1961 · S/N 23-2026N73WHBumble Bee Aviation LLC · Brookfield, WIS/N 27-7305184N740HCVuksanovic David A · Fountain Hills, AZBuilt 1984 · S/N 31P-8414043N74199Aldrich Curtiss R · Aguila, AZBuilt 1965 · S/N 27-3026N7436CMatanane Roke C · Barrigada, GUBuilt 1976 · S/N 27-7754017N743SLLewis And Hart Development LLC · Nashville, TNBuilt 1984 · S/N 31P-8414037N744JCAck-Pg-LLC · Charlestown, MABuilt 1979 · S/N 31-7912119N747ATHaueisen Jessica · Franklin, GABuilt 1978 · S/N 27-7854080N747CGAir Americus LLC · Johns Creek, GABuilt 1981 · S/N 31-8152070N747WWN Registration Services LLC Trustee · Sanford, NCS/N 27-4330N7482WSkys Edge Aviation LLC · Midland, TXS/N 27-3524N74932Ruocco 220 LLC · Escondido, CABuilt 1973 · S/N 31-7305074N74972H&H Aircraft LLC · Grey Eagle, MNBuilt 1973 · S/N 31-7305123N74ABAerial Digital Images LLC · Huntington Beach, CABuilt 1959 · S/N 23-1656N74BBHy Aviation LLC · San Juan, PRBuilt 1971 · S/N 27-4750N74DDN74dd Inc · Apalachicola, FLBuilt 1978 · S/N 31-7952016N74LKAlexander 3 Aviation LLC · Rincon, GAS/N 31-8012038N74LRRemy Lange · East Greenville, PAS/N 27-7405363N74MJFord Richard M · Cartersville, GABuilt 1977 · S/N 31-7712065N74PLAncient Pelican Aviation LLC · Vero Beach, FLS/N 27-7405272N7576YJ & P Toys Inc · Fort Myers, FLBuilt 1968 · S/N 27-4076N75AWSemper Blue Aviation LLC · New Braunfels, TXBuilt 1981 · S/N 42-8001046N75LKN75lk LLC · Lafayette, LABuilt 1981 · S/N 31-8152173N762SASua 762sa Inc · Palm City, FLBuilt 1979 · S/N 31-7912042N762SUAlmost There Air LLC · Daytona Beach, FLBuilt 1977 · S/N 27-7754003N765KPMarc Inc · Bolton, MSBuilt 1982 · S/N 31-8253012N766CFAirplane Five LLC · Miami, FLBuilt 1973 · S/N 31-7305102N767RJS&S Aircraft Inc · Bennington, VTBuilt 1964 · S/N 27-2651N767SCClegg Stephen A · Port Orange, FLBuilt 1977 · S/N 27-7754060N7694LLowell Darryl S · Anchorage, AKBuilt 1973 · S/N 31-7305024N769MCRhs Consulting Ltd · Reno, NVBuilt 1973 · S/N 31P-7300131N76AWPacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554100N76FCBlackhawk Holding Corp · Wilmington, DEBuilt 1976 · S/N 27-7654082N76HKDodson International Parks Inc · Rantoul, KSBuilt 1958 · S/N 23-1423N76JNGross Charles C III · Mims, FLBuilt 1976 · S/N 31-7652176N76NATri Flying Tigers Inc · Wilmington, DEBuilt 1960 · S/N 23-1909
Back to AD 2009-13-06 R1