AD 2011-18-09

Registered aircraft · 128

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:2011-18-09')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-18-09')
  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.

N5078GFresh Air Aviation Inc · Charlevoix, MIBuilt 1960 · S/N LF-8N5078NBemidji Aviation Services Inc · Bemidji, MNS/N LF-16N5078UBemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LF-32N5079EBemidji Aviation Services Inc · Bemidji, MNS/N LF-52N5080GQuinlan John H DBA · Claxton, GABuilt 1962 · S/N LF-35N5080HBemidji Aviation Services Inc · Bemidji, MNBuilt 1961 · S/N LF-27N57084Sunflower Aviation LLC · Wilmington, DEBuilt 1974 · S/N 3184N6174ADakota Air Spray LLC · Huron, SDS/N 36-8102016N62AXArrow Air Services LLC · Greenleaf, IDS/N 99-7224N63FSandella William A · Medfield, MABuilt 1964 · S/N 26-57N64400Mascari M Richard · Iowa City, IABuilt 1964 · S/N 26-36N702JDCrossbow Aviation LLC · Reno, NVBuilt 1965 · S/N 26-93N711SAGordon Wesley · Portland, ORS/N 0001N7262VAirplane Services Inc · Jay, FLBuilt 1966 · S/N 10009N76400Horning Air LLC · Cresbard, SDBuilt 1976 · S/N 36-7660096N772SAero Legacy Foundation · Leavenworth, KSS/N 04467N777MURobinson James G · Baltimore, MDBuilt 1964 · S/N 26-83N780MMTrike Industries LLC · Draper, UTBuilt 2021 · S/N CCK-2000-0043N800EQMccauley Kerry D · Menomonie, WIBuilt 1960 · S/N LF-24N800TTwin Aviation LLC · Coushatta, LABuilt 1960 · S/N 98633N810ADGulf States Air Inc · Bossier City, LAS/N LD-328N8400PPiper Aviation Museum Foundation Inc · Lock Haven, PABuilt 1963 · S/N 26-3N8401PPrecision Design Inc · Weatherford, OKBuilt 1963 · S/N 26-4N840STransnational Aviation LLC · Arlington, TXBuilt 1962 · S/N LF-38N8414PRudd Wayne · Basalt, COBuilt 1965 · S/N 26-8N8421PWills Terry W · Cedar Park, TXBuilt 1964 · S/N 26-12N8438PCrews Cobert J · Shady Shores, TXBuilt 1964 · S/N 26-6N8440PSpoor John B · Sandwich, ILBuilt 1964 · S/N 26-21N8448PBissell Lee · Culver, ORBuilt 1964 · S/N 26-25N844NBemidji Aviation Services Inc · Bemidji, MNS/N LF-42N8450PKroll Corey · Gilbert, SCBuilt 1964 · S/N 26-26N8455PTcb Properties Ltd · Wilmington, DEBuilt 1964 · S/N 26-120N8456PBeckmann Gerhard David · Covington, LABuilt 1964 · S/N 26-31N8458PSchoolcraft Carl L · West Harrison, INBuilt 1964 · S/N 26-33N8459PDiesel LLC · Concord, NCBuilt 1964 · S/N 26-34N8460PLadet William D · Las Vegas, NVBuilt 1964 · S/N 26-35N8465PHorton Charles S Jr · Diamondhead, MSBuilt 1964 · S/N 26-40N8466PBrindeiro Stephen M · Artesia, NMBuilt 1964 · S/N 26-41N8468PLucy Douglas S · Apple Valley, CABuilt 1964 · S/N 26-43N846LAAlfieri Louis · Middleton, NHS/N WG-600-2N8474PCopass Benjamin J · Fountain Run, KYS/N 26-49N8475PBlackdog Air LLC · Wilmington, DEBuilt 1964 · S/N 26-53N8477PD F Osborne Construction Inc · Topeka, KSBuilt 1964 · S/N 26-55N847SPRothschild Joel S · Crestline, CABuilt 1964 · S/N 26-48N8480PGlaser Violet E · Calhan, COBuilt 1964 · S/N 26-58N8481PBailey Roger R · Mineral, TXBuilt 1964 · S/N 26-60N8482PHogan John Robert · Palm Beach Gardens, FLBuilt 1964 · S/N 26-61N8483PHigh Wing Aviation LLC · Sardis, MSBuilt 1964 · S/N 26-62N8486PHaawq Air LLC · Brookshire, TXS/N 26-65N8491PHansen Jed D · Clark, SDBuilt 1965 · S/N 26-70
Back to AD 2011-18-09