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.

N924CJRegistration Pending · Dover, DERegistration pendingBuilt 2014 · S/N 1024N924PMRegal Air Partners Tbm960 LLC · New Iberia, LABuilt 2023 · S/N 1482N924WPNine Hills Aviation LLC · Raleigh, NCBuilt 2016 · S/N 1134N925ASCalkun Wings LLC · Lakewood Ranch, FLBuilt 2025 · S/N 1617N925MACt-Dtsi Aviation LLC · Waverly, NEBuilt 2020 · S/N 1357N930AKMcfly Air LLC · Downers Grove, ILBuilt 2016 · S/N 1121N930ARRigidworks LLC · Helena, MTBuilt 2016 · S/N 1119N930AXBeta Fleet LLC · South Burlington, VTBuilt 2017 · S/N 1191N930BKPortie LLC · Delano, MNBuilt 2017 · S/N 1179N930BPJ R C Aviation LLC · El Prado, NMBuilt 2016 · S/N 1131N930BWNorth Fork Aviation LLC · Camden, DEBuilt 2017 · S/N 1167N930CFHynes Kevin P · Wichita Falls, TXBuilt 2016 · S/N 1157N930DFCrusader Logistics LLC · Dover, DEBuilt 2016 · S/N 1115N930DH1257 Inc Trustee · Wilmington, DEBuilt 2018 · S/N 1257N930DVOlsa Aviation LLC · Mossville, ILBuilt 2017 · S/N 1202N930DXCrusader Logistics LLC · Dover, DEBuilt 2017 · S/N 1164N930EAHarlan Aviation LLC · Atlantic, IABuilt 2017 · S/N 1175N930FRegistered aircraftBuilt 2017 · S/N 1204N930FPAiello Robert M · Bossier City, LABuilt 2016 · S/N 1151N930FRTbm 930 LLC · Oshkosh, WIBuilt 2016 · S/N 1144N930FYBar Harbor Bank & Trust · Bar Harbor, MEBuilt 2017 · S/N 1189N930GEInternational Aerospace LLC · Dover, DEBuilt 2017 · S/N 1195N930GMPerihelion Aviation LLC · Los Gatos, CABuilt 2016 · S/N 1123N930GWRegistered aircraftBuilt 2016 · S/N 1155N930HAgiliti Leasing LLC · Eden Prairie, MNBuilt 2016 · S/N 1137N930JAdi Consulting LLC · Scottsdale, AZBuilt 2017 · S/N 1176N930KAWynfall Leasing LLC · Park City, UTBuilt 2016 · S/N 1135N930KFRegistered aircraftBuilt 2017 · S/N 1185N930LXTriple S Resources LLC · Sunrise, FLBuilt 2018 · S/N 1250N930MLAir Support Service LLC · Whitefish, MTBuilt 2017 · S/N 1180N930MPP&P Aviation LLC · Salem, ORBuilt 2017 · S/N 1165N930PMMore Than A Bonanza LLC · Helena, MTBuilt 2018 · S/N 1255N930PWGrand Mission LLC · Newark, DEBuilt 2018 · S/N 1236N930RAMosby Group LLC · Edgerton, MOBuilt 2016 · S/N 1146N930RCAirmann Leasing LLC · Mount Sterling, KYBuilt 2017 · S/N 1171N930RDFlanagan Contracting LLC · Birmingham, ALBuilt 2018 · S/N 1240N930RKSchwarting Carsten · Short Hills, NJBuilt 2018 · S/N 1261N930RSAviation Management II LLC · Des Moines, IABuilt 2016 · S/N 1140N930SRRiverside Broncho LLC · Redlands, CABuilt 2017 · S/N 1183N930TAMckenna & Associates LLC · Arlington, VABuilt 2016 · S/N 1139N930TDMeridian 37 LLC · Dover, DEBuilt 2018 · S/N 1244N930TTQupon Air Holdings LLC · Hewlett, NYBuilt 2018 · S/N 1228N930VMBlue Altitude LLC · Newtown, PABuilt 2016 · S/N 1147N930VTHusky Air Corp · Scipio Center, NYBuilt 2016 · S/N 1153N930WDElite Flight Group LLC · Charlotte, NCBuilt 2016 · S/N 1152N930XD41 North Capital LLC · Mars, PABuilt 2017 · S/N 1177N930XXAutocata LLC · Fort Lauderdale, FLBuilt 2016 · S/N 1122N930YYTitan 1023 LLC · Houston, TXBuilt 2016 · S/N 1124N930YZClear Rocket LLC · Los Angeles, CABuilt 2018 · S/N 1258N930ZDPhilosophy Aviation LLC · Middleburg, VABuilt 2017 · S/N 1216
Back to AD 2007-03-17 R1