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.

N700ZZEastern Aviation Fuels Inc · New Bern, NCBuilt 1995 · S/N 116N701AVTango Alpha Sierra LLC · Austin, TXBuilt 2000 · S/N 179N701CNScouts Rest Ranch LLC · Darby, MTBuilt 2003 · S/N 260N701JFJ Fergus Inc · Lewis Center, OHBuilt 2005 · S/N 331N702AALantech Leasing LLC · Louisville, KYBuilt 2001 · S/N 216N702AROro Grande Mining Claims LLC · Anchorage, AKBuilt 2003 · S/N 275N702UT400 Knot Aviation LLC · Amarillo, TXBuilt 2006 · S/N 376N702WMWalker Manufacturing Co · Fort Collins, COBuilt 2002 · S/N 245N705JSRmp Transportation LLC · Greenwich, CTBuilt 2001 · S/N 195N707AVCarvair LLC · New York, NYBuilt 2001 · S/N 197N707FBBolea Air Inc · Morgan Hill, CAS/N 177N708CGGbo-Air LLC · Hopkinsville, KYBuilt 2002 · S/N 220N708EFDejong Merritt · Newburgh, INS/N 21N708JPFly696cc LLC · Sisters, ORBuilt 2017 · S/N 1199N709MMYl Management LLC · Oak Hill, VABuilt 2009 · S/N 528N70AVQualitair LLC Trustee · MichelstadtBuilt 1991 · S/N 6N70LTBarren Troy Aviation LLC · Centennial, COBuilt 1999 · S/N 151N70SGGreen Mountain Aviation LLC · Hillsborough, CAS/N 1584N711PMVinton Aero LLC · Cedar Springs, MIBuilt 2002 · S/N 234N711PPWalsh Stephen Robert · Rochester, NYBuilt 2018 · S/N 1223N712HFFues Aviation LLC · Oconomowoc, WIBuilt 2023 · S/N 1481N712LRDz Holdings LLC · Hauppauge, NYBuilt 2011 · S/N 592N713KBAero Ip LLC · Ann Arbor, MIBuilt 2021 · S/N 1384N715VTnt Operations LLC · Missoula, MTBuilt 1995 · S/N 108N716MAMcclelland John J · Edinburg, TXBuilt 2004 · S/N 310N71EEKalisetsi LLC · Hillsborough, CABuilt 2005 · S/N 343N71WJTbm One Aviation LLC · Milford, CTBuilt 1990 · S/N 001N720CJValiair Limited Co Trustee · Casper, WYBuilt 1999 · S/N 153N720MJAardsma Mark · Foosland, ILS/N 34N720WAWhiskey Alpha LLC · Lexington, KYBuilt 2003 · S/N 272N721MBDgw Enterprises LLC · Edina, MNS/N 91N721SRNcs Aviation LLC · Bemidji, MNBuilt 2000 · S/N 181N722WFHunt Pacific Management Corp · Newport Beach, CABuilt 2024 · S/N 1529N723BC723bc LLC · Lewes, DEBuilt 2008 · S/N 490N724DMBusker Aviation LLC · Detroit Lakes, MNBuilt 1999 · S/N 143N724JATres Rapide LLC · Delray Beach, FLBuilt 2024 · S/N 1548N728VSDega Aviation LLC · Genoa, NVBuilt 2024 · S/N 1526N729MK729mk LLC · Inlet Beach, FLS/N 1641N72SWWatery Domestic LLC · Telluride, COS/N 1646N738TSThree Sisters Aviation LLC · Olympia, WABuilt 2014 · S/N 1038N73ACAdams Land & Cattle LLC · Broken Bow, NEBuilt 2023 · S/N 1491N742DRPbtx LLC · Dover, DEBuilt 2022 · S/N 1427N744AMBuenting John E · Sylva, NCBuilt 2005 · S/N 312N74MASierra Tango Air LLC · Sycamore, ILS/N 385N750ABNpa Aviation LLC · Lafayette, LABuilt 1991 · S/N 4N753BLBlackjack Express 340 LLC · Santa Barbara, CABuilt 1991 · S/N 13N753CAMoon Mountain Montana LLC · Missoula, MTBuilt 2000 · S/N 163N753MATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 1544N755DMMdst Aircraft Leasing LLC · Ripon, WIBuilt 1994 · S/N 101N755ZR8992 Air LLC · Whitman, NEBuilt 2012 · S/N 637
Back to AD 2007-03-17 R1