OpenAirDocs.org
AD 2009-13-06 R1

Registered aircraft · 2,131

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.

N1384PHanson Roddy L · Butterfield, MNBuilt 1956 · S/N 23-434N13862Reliance Island Inc · Wilmington, DEBuilt 1970 · S/N 27-4500N13865Enzed Aviation Services LLC · Anchorage, AKS/N 27-4503N13882Gc Aviation Services-1 LLC · Miamisburg, OHBuilt 1970 · S/N 27-4517N138RA & K Aviation LLC · Wenatchee, WABuilt 1972 · S/N 317300935N13901Masscotte Michael · Mansfield, MABuilt 1970 · S/N 27-4533N1393PSeymour Lori L · Woodstock, GAS/N 23-445N13950Bml Aviation LLC · Arvada, COBuilt 1970 · S/N 27-4567N13966Chesapeake Aviation LLC · Lewes, DEBuilt 1970 · S/N 27-4581N13980Aileron Buzz LLC · Daytona Beach, FLBuilt 1970 · S/N 27-4598N13982Bray Aviation LLC · Calera, OKBuilt 1970 · S/N 27-4600N13984Smith Aircraft Holdings Inc · Wilmington, DEBuilt 1970 · S/N 27-4602N13987Island Birds Inc · St Thomas, VIBuilt 1971 · S/N 27-4605N13998Granger Vic · Union Grove, ALS/N 27-4616N139CSCheyenne Flight Group LLC · Wallingford, CTS/N 31T-8120004N139DBWolfe LLC · Rogers, TXS/N 27-4611N13ALNorthstar Holdings LLC · Anchorage, AKBuilt 1976 · S/N 31-7752009N13BRC-140 Co LLC · Pensacola, FLBuilt 1963 · S/N 27-532N13CAAeroclub Management LLC · Cincinnati, OHBuilt 1974 · S/N 31-7405411N13ESCsl Holdings LLC · Drayton, NDBuilt 1977 · S/N 31-7812046N13NEQualitair LLC Trustee · MichelstadtBuilt 1984 · S/N 31P-8414035N13TTKlcc Holdings LLC · Boca Raton, FLS/N 27-7554069N14005Delaware Aircraft Trust LLC Trustee · New Castle, DES/N 27-4623N14009Livingston Aviation Inc · Waterloo, IABuilt 1971 · S/N 27-4627N14012Rock Valley College · Rockford, ILBuilt 1971 · S/N 27-4629N14028Stoks Derek R · Canby, MNS/N 27-4689N14036Booth Donald V · Denison, TXBuilt 1971 · S/N 27-4648N14040Island Aviation Inc Trustee · Wilmington, DEBuilt 1971 · S/N 27-4654N14051Sams Way · Eagle Mountain, UTBuilt 1971 · S/N 27-4663N14078Tundra Aviation Inc · Casselton, NDS/N 27-4679N14089Szymanski Tadeusz · Fort Myers, FLS/N 27-4687N140RDAlpha Whiskey 3 LLC · Brandon, MSBuilt 1975 · S/N 31-7552051N14133C I Holdings Ltd Inc · Lewes, DES/N 27-4701N14135Olympiakh LLC · Louisville, KYBuilt 1971 · S/N 27-4702N14138Island Bound LLC · Dunedin, FLS/N 27-4704N14149Ninja Turtle LLC · Orlando, FLBuilt 1971 · S/N 27-4712N14175Box Aviation Inc · Montgomery, ALBuilt 1971 · S/N 27-4739N14183Osborne Donald R · Fairbury, NEBuilt 1971 · S/N 27-4747N141MEFox Heather J · Bettles Field, AKBuilt 1981 · S/N 31-8152117N141TCEhs Aircraft LLC · Wilmington, DEBuilt 1984 · S/N 42-5501021N14202Hodge Uriel · St Thomas, VIS/N 27-4762N14207Belk William E · Labelle, FLBuilt 1971 · S/N 27-4767N14224Townley William V · Weirsdale, FLBuilt 1972 · S/N 27-4783N14229Holt Bryan J · Flowery Branch, GABuilt 1972 · S/N 27-4794N14243Blitz Daniel R · Corsicana, TXBuilt 1972 · S/N 27-4795N14244Pacific Fleet Aviation LLC · Rochester, NYBuilt 1972 · S/N 27-4796N14252Caja Aviation LLC · Cheyenne, WYBuilt 1972 · S/N 27-4813N14268Kilgore Garrett M · Whitwell, TNS/N 27-4828N1426SBoundless LLC · Dakota Dunes, SDBuilt 1971 · S/N 27-4680N1427SCasa Jets Inc · Pittsford, NYS/N 27-4831
Back to AD 2009-13-06 R1