OpenAirDocs.org
AD 2007-03-17 R1

Registered aircraft · 999

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:2007-03-17-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:2007-03-17-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.

N904JLJackson Aviation Tbm 960 LLC · Jacksonville, FLBuilt 2025 · S/N 1589N90KJDawson Aero LLC · Fayetteville, ARBuilt 2015 · S/N 1055N910ABEkster LLC · Victor, IDBuilt 2017 · S/N 1178N910CHSilverado LLC · Olmito, TXBuilt 2018 · S/N 1263N910DDBtp Aviation LLC · Vero Beach, FLBuilt 2018 · S/N 1238N910DHTbm Aviation LLC · Longview, TXBuilt 2017 · S/N 1174N910DZN910dz LLC · Lovell, WYBuilt 2014 · S/N 1035N910EAJ&L Aviation LLC · Berlin, WIBuilt 2017 · S/N 1187N910EETbm 646 LLC · Boca Raton, FLBuilt 2019 · S/N 1274N910ERRiedel Lance Alan · Austin, TXBuilt 2019 · S/N 1273N910FAUnited American Steel Company Inc · Waxhaw, NCBuilt 2010 · S/N 550N910GEConsol Home Energy Effiency Ratings Services 45l · Sacramento, CABuilt 2018 · S/N 1221N910GUValiair Lc Trustee · Casper, WYBuilt 2021 · S/N 1396N910KBRafter K LLC · Wilmington, DEBuilt 2018 · S/N 1264N910LInnw LLC · Fort Worth, TXBuilt 2018 · S/N 1256N910LMSpud Seller Inc · Monte Vista, COBuilt 2018 · S/N 1268N910MDDesch Matthew J · Mclean, VABuilt 2017 · S/N 1173N910MEPlj700pv LLC · King Of Prussia, PABuilt 2017 · S/N 1208N910MXSmith Ben R · Eads, TNBuilt 2017 · S/N 1186N910PAAlanlee Logistics LLC · Raleigh, NCBuilt 2017 · S/N 1205N910PBUpper Cumberland Aviation LLC · Cookeville, TNBuilt 2017 · S/N 1214N910PKRegistered aircraftBuilt 2018 · S/N 1245N910QW E F Air Inc · Valparaiso, INBuilt 2019 · S/N 1279N910RTThompson Aviation Interests LLC · Dallas, TXBuilt 2017 · S/N 1193N910TBSpeedbird Aviation LLC · Austin, TXBuilt 2017 · S/N 1170N910VMLittle Hawk Logistics LLC · North Garden, VABuilt 2017 · S/N 1184N910WZPonthie Holdings LLC · Alexandria, LABuilt 2017 · S/N 1210N910XXWest Texas Flyers Inc · Fredericksburg, TXBuilt 2018 · S/N 1218N910ZAValiair Lc Trustee · Casper, WYBuilt 2017 · S/N 1194N910ZBJohn Madonna Construction Co Inc · San Luis Obispo, CABuilt 2018 · S/N 1252N910ZV910 Zv LLC · Hot Springs, ARBuilt 2018 · S/N 1242N913MCDreamweaver LLC · Chesapeake, VABuilt 2022 · S/N 1412N913TMReseda Equipment Inc · Alta, WYBuilt 2019 · S/N 1277N914CFFrankum Aviation LLC · Denver, COBuilt 2012 · S/N 635N915MMSpitfire LLC · Sheridan, WYBuilt 2016 · S/N 1120N916CMPlanewx Aviation LLC · Sheridan, WYBuilt 2015 · S/N 1080N917BTMartin Air LLC · Clyde, NYBuilt 2017 · S/N 1209N917KRAction Aviation LLC · Idaho Falls, IDBuilt 2000 · S/N 176N919EAArrow 2000 LLC · Norfolk, NEBuilt 2018 · S/N 1248N91KDLongbow Aviation LLC · Henderson, NVBuilt 2010 · S/N 541N91PXAh Leasing LLC · Newark, DEBuilt 2011 · S/N 571N91WKFloyd Ventures LLC · Fort Worth, TXBuilt 2015 · S/N 1050N91WTS&M Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 658N920EACrimson & Cream Aviation LLC · Norman, OKBuilt 2014 · S/N 1020N921MCBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 1059N922AWKiyaya Aviation LLC · San Antonio, TXBuilt 2026 · S/N 1631N922BGTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 531N922GGTransatlantic Deliveries Trust · Wilmington, DES/N 1673N923CFSierra Kilo LLC · Midland, MIBuilt 2025 · S/N 1586N924BBWayne Riser LLC · Aspen, COBuilt 2007 · S/N 405
Back to AD 2007-03-17 R1