OpenAirDocs.org
AD 2009-21-08 R1

Registered aircraft · 110

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-21-08-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-21-08-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.

N100EVCasey Key Two LLC · Newark, DEBuilt 2022 · S/N 3013N1037WWinslow Avanti LLC · Camden, DEBuilt 2001 · S/N 1037N105GPP-1048 LLC · Nashville, TNS/N 1048N105SLSouthwest Aviation Specialties LLC · Tulsa, OKBuilt 2003 · S/N 1068N107SLSouthwest Aviation Specialties LLC · Tulsa, OKBuilt 2003 · S/N 1073N109MSCavallino Rampante Inc · Dover, DEBuilt 1991 · S/N 1008N111VRDftf LLC · Des Moines, IABuilt 1991 · S/N 1006N111ZZKnight Wings LLC · Matthews, NCBuilt 2007 · S/N 1145N134ECFly Invest Inc Trustee · Wilmington, DEBuilt 2008 · S/N 1160N134JTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 1134N145SLCash Depot Ltd · Green Bay, WIBuilt 2004 · S/N 1093N146SLDodson International Parts Inc · Rantoul, KSS/N 1091N153SLSouthwest Aviation Specialties LLC · Tulsa, OKBuilt 2002 · S/N 1054N155SYRocky Mountain Aviation LLC · Aberdeen, IDBuilt 1992 · S/N 1013N160SLCash Depot Ltd · Green Bay, WIBuilt 2007 · S/N 1127N163LFRdt Air LLC · Hattiesburg, MSBuilt 2007 · S/N 1136N174WABeta Business LLC · Charlottesville, VABuilt 2004 · S/N 1074N17PASailfin Partners LLC · Southfield, MIS/N 1017N180AVAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1996 · S/N 1018N180BPAvanti 180 LLC · Anaheim, CABuilt 1990 · S/N 1004N180FBTj Air Holdings Inc Trustee · Wilmington, DEBuilt 2003 · S/N 1069N184AVLmdc Aviation LLC · Eclectic, ALBuilt 2007 · S/N 1123N184LWVenture Pilots Association LLC · Alpine, WYBuilt 2009 · S/N 1187N189LW810 Aviation LLC · Charlottesville, VABuilt 2009 · S/N 1181N192LWRegal Air Tools LLC · New Iberia, LABuilt 2009 · S/N 1199N194SVLa Aviation LLC · Orlando, FLS/N 1214N196SLQualitair LLC Trustee · MichelstadtBuilt 2011 · S/N 1216N197MSPierwest Aviation LLC · Tulsa, OKBuilt 2011 · S/N 1215N212KKN212kk LLC · Tampa, FLBuilt 2000 · S/N 1040N221JDPerrydise Aviation LLC · Tulsa, OKBuilt 1991 · S/N 1010N224JDPerrydise Aviation LLC · Tulsa, OKBuilt 2007 · S/N 1141N228KSKs Blackwood Properties LLC · Midland, TXBuilt 2007 · S/N 1132N234ELElg Air LLC · Birmingham, ALBuilt 2008 · S/N 1153N234VVTwo Ts LLC · Greenbrier, ARBuilt 2002 · S/N 1056N2444ZAlyvia Aviation II LLC · Sarasota, FLBuilt 2004 · S/N 1089N247JLElevon Aviation LLC · Torrance, CABuilt 2010 · S/N 1207N260HMUpward Aviation LLC · Bixby, OKBuilt 2006 · S/N 1120N267TAFoxfire Aviation LLC · Tulsa, OKBuilt 2005 · S/N 1107N268TAPierwest Aviation LLC · Tulsa, OKS/N 1146N288LAWoodpecker LLC · Seneca, KSBuilt 2008 · S/N 1176N290BCTraven Ricardo Siro · Georgetown, SCBuilt 2004 · S/N 1092N2MKItalian Job Holdings LLC · Johnstown, OHBuilt 2003 · S/N 1063N306MSCritical Mass Aviation LLC · Coral Springs, FLBuilt 2008 · S/N 1166N320TCOff The Chain Aviation LLC · Orlando, FLBuilt 2022 · S/N 3014N327AD & S Mafco LLC · Tilden, TXBuilt 2008 · S/N 1158N327MJTour Aviation LLC · Naples, FLBuilt 2005 · S/N 1099N327YRElray Aviation LLC · Dallas, TXBuilt 2008 · S/N 1173N33MCTwin Rivers Aircraft LLC · Sebastopol, CABuilt 2001 · S/N 1051N360MCPgv LLC · Camden, DEBuilt 2006 · S/N 1119N369EBEarths Brew LLC · Leesburg, VAS/N 1062
Back to AD 2009-21-08 R1