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.

N930ZFAdvisors Academy Air LLC · Fort Lauderdale, FLBuilt 2018 · S/N 1227N931MCSandcastle Stables LLC · Camden, DES/N 1156N931MGJk Aviation LLC · York, NEBuilt 2016 · S/N 1145N933EAHudson Pro Aviation II LLC · Secaucus, NJBuilt 2018 · S/N 1237N937CAAjmlt Aviation Inc · Anaconda, MTBuilt 2017 · S/N 1201N93BLLashinski Robert D Trustee · Sebastopol, CABuilt 2017 · S/N 1198N93BNPeter Litchfield M D LLC · Nashville, TNS/N 74N9401Darkhorse Aviation LLC · Lake Wales, FLBuilt 2021 · S/N 1399N940ABJvc Aviation LLC · Friendsville, PABuilt 2020 · S/N 1341N940ARValley View Aviation LLC · Norfolk, VABuilt 2019 · S/N 1301N940AUBetween The Blues LLC · East Hampton, NYBuilt 2019 · S/N 1300N940AWLyv 26 Inc Trustee · Wilmington, DEBuilt 2021 · S/N 1386N940AXBobo Donald E Jrtrustee · Santa Ana, CABuilt 2019 · S/N 1298N940BHorseshoe Aviation LLC · Streetsboro, OHBuilt 2020 · S/N 1330N940CMCanter Aviation LLC · La Jolla, CABuilt 2021 · S/N 1359N940CSJmc79 LLC · Springfield, MOBuilt 2019 · S/N 1283N940CWCmw Aviation LLC · Alpine, WYBuilt 2021 · S/N 1390N940CXOso Rio LLC · Houston, TXBuilt 2019 · S/N 1309N940DDCheviot LLC · Washington, DCBuilt 2020 · S/N 1344N940DF4jn LLC · Acton, MABuilt 2020 · S/N 1314N940DKEdson Aviation LLC · Lake Oswego, ORBuilt 2019 · S/N 1312N940DM1375 Aviation Inc Trustee · Wilmington, DEBuilt 2021 · S/N 1375N940DRSl-Rose LLC · Monterey, CABuilt 2019 · S/N 1302N940ELalin LLC · Newark, DEBuilt 2021 · S/N 1387N940ELRed Tail Aviation LLC · Trenton, NJS/N 1333N940EMBison Aviation LLC · Jupiter, FLS/N 1339N940ESTdaw LLC · Delray Beach, FLBuilt 2021 · S/N 1402N940FRDiamond Rim Holdings LLC · Scottsdale, AZBuilt 2020 · S/N 1318N940HWArapahoe Leasing LLC · Sarasota, FLBuilt 2020 · S/N 1327N940JJTbm 850 LLC · Madison, MSBuilt 2019 · S/N 1286N940KDKilodelta LLC · Littleton, NCBuilt 2015 · S/N 1100N940LARaf Ks LLC · Wichita, KSBuilt 2019 · S/N 1275N940LGRicketson Contstruction Company Inc · Douglas, GABuilt 2022 · S/N 1407N940LTTbmair LLC · Minneapolis, MNBuilt 2019 · S/N 1296N940MDArbutina Airlines LLC · Raleigh, NCBuilt 2019 · S/N 1308N940MERoney Leasing LLC · Saint Petersburg, FLBuilt 2019 · S/N 1272N940MSDelta Romeo Holdings LLC · Lewes, DEBuilt 2021 · S/N 1361N940MVSuite Six LLC · Concord, NHBuilt 2021 · S/N 1378N940PDOlin River Tbm LLC · Atlanta, GABuilt 2019 · S/N 1288N940PKN940pk Inc Trustee · Wilmington, DEBuilt 2020 · S/N 1328N940PPFresh Equipment LLC · Milford, OHBuilt 2021 · S/N 1393N940PSRegistered aircraftBuilt 2019 · S/N 1281N940PWBoatwright Jonathan M · Austin, TXBuilt 2019 · S/N 1306N940RWEastern Stearman Inc Trustee · Leesburg, VABuilt 2019 · S/N 1303N940SBGtl Aviation LLC · Houston, TXBuilt 2020 · S/N 1315N940SGAircraft Guaranty Corporation Trustee · Oklahoma City, OKS/N 1392N940TBlue Sky Aviation LLC · Newark, DEBuilt 2020 · S/N 1346N940TBTbm207 Corp Trustee · Wilmington, DEBuilt 2019 · S/N 1294N940TMEt Investments LLC · Parker, COBuilt 2020 · S/N 1332N940TWFront Street Capital Of Nc Inc · Winston Salem, NCBuilt 2019 · S/N 1282
Back to AD 2007-03-17 R1