OpenAirDocs.org
AD 80-04-06

Registered aircraft · 44

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

N1009FDavidson Richard E · Tchula, MSBuilt 2019 · S/N T34-484N283TATommys Flying Service · Sherrill, ARBuilt 2009 · S/N T34-314DCN3000HNorth Florida Ag Services Inc · Lake City, FLBuilt 2012 · S/N T34-402N3006CNewkirk Thomas DBA · Garland, NCBuilt 2012 · S/N T34-403N3043VMccool Air Service Inc · Mc Cool Junction, NEBuilt 2013 · S/N T34-422N3045HPesicka Theodore J · Hermiston, ORBuilt 2013 · S/N T34-411N3052VFederal Aerial Applicators LLC · Wilmington, DEBuilt 2012 · S/N T34-374N3055MChorman Spraying LLC · Milton, DEBuilt 2012 · S/N T34-381N30601Longwood Flying Service Inc · Hollandale, MSBuilt 2012 · S/N T34-400N3060DMcelwain Russell · Lancaster, KSBuilt 2012 · S/N T34-383N30620Mccool Air Service Inc · Mc Cool Junction, NEBuilt 2013 · S/N T34-407N3067XSamson Ag Flying LLC DBA · Wilmington, DEBuilt 2006 · S/N T34-278N318LGLow Go Flyers Inc · Jonesville, LABuilt 2014 · S/N T34-421DCN339LGKingsley Kiman · Miller, MOBuilt 2011 · S/N T34-347DCN40358Tri-Rotor Spray & Chemical · Ulysses, KSBuilt 2005 · S/N T34-273N40428H And M Flying Service LLC · Osceola, ARBuilt 2005 · S/N T34-274N5101CThrush Aircraft LLC · Albany, GABuilt 2020 · S/N T34-502N5102AThrush Aircraft LLC · Albany, GABuilt 2020 · S/N T34-503N510TFederal Aerial Applicators LLC · Wilmington, DES/N T34-311N524SVAaa Aviation LLC · Donalsonville, GABuilt 2015 · S/N T34-438N5297FTri Rotor Spray & Chemical · Ulysses, KSBuilt 2009 · S/N T34-307N5298FBarnett Air LLC · Nezperce, IDBuilt 2009 · S/N T34-313N5298HCrop Dusters LLC · Maurice, IABuilt 2009 · S/N T34-312N5301WTurrell Flying Service Inc · Turrell, ARBuilt 2009 · S/N T34-308N5306BWorsham Farms Flying Service Inc · Camilla, GABuilt 2010 · S/N T34-332N5308SCrop Dusters LLC · Maurice, IABuilt 2010 · S/N T34-326DCN5539DThree Five Julier LLC · Winamac, INBuilt 2018 · S/N T34-478N562XChorman Spraying LLC · Milton, DEBuilt 2012 · S/N T34-380N6203DField & Farm Aviation LLC · Hawkinsville, GABuilt 2014 · S/N T34-423N62139A-T Rental Properties LLC · Tivoli, TXBuilt 2016 · S/N T34-434DCN64DQLongwood Flying Service Inc · Hollandale, MSBuilt 2012 · S/N T34-391N655TATommys Flying Service Inc · Sherrill, ARBuilt 2008 · S/N T34-285DCN70009A-T Rental Properties LLC · Tivoli, TXBuilt 2011 · S/N T34-338N7003QLowry Flying Service Inc · Grinnell, IABuilt 2011 · S/N T34-343N7005BSky Force Travel LLC · Jamestown, NDBuilt 2011 · S/N T34-359N7008MLongwood Flying Service Inc · Hollandale, MSBuilt 2011 · S/N T34-362N7013FWimberly Lane W · Cochran, GABuilt 2012 · S/N T34-372N701TVVaughns Flying Service Inc · Reese, MIBuilt 2011 · S/N T34-366DCN70224Agricair Leasing LLC · Bancroft, WIBuilt 2010 · S/N T34-341N7022FTommys Flying Service Inc · Sherrill, ARBuilt 2010 · S/N T34-334N7024JSchindler Flying Inc · Neligh, NEBuilt 2010 · S/N T34-336N753WCPrecision Air Tactics LLC · Welton, AZS/N 2548RN92JASouther Field Aviation Inc · Americus, GABuilt 2020 · S/N T34-505DCN986MMGarrett Flying Service Inc · Danbury, TXBuilt 2011 · S/N T34-369
Back to AD 80-04-06