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.

N850HAHughes Aerospace Aviation Services LLC · Wilmington, DEBuilt 2007 · S/N 389N850HDShakedown Street LLC · Camden, DEBuilt 2013 · S/N 674N850HPRegistered aircraftBuilt 2008 · S/N 437N850HRKnox Air LLC · Secaucus, NJBuilt 2012 · S/N 625N850JB850 Jb LLC · Madison, WIBuilt 2006 · S/N 365N850JHBgd LLC · Fort Wayne, INBuilt 2008 · S/N 448N850JWProp It Up LLC · Ponca City, OKBuilt 2011 · S/N 603N850KAEyefly Consultants LLC · Apalachin, NYBuilt 2011 · S/N 601N850KDMinka-Air Inc · Wilmington, DEBuilt 2012 · S/N 638N850KHInnisfree LLC · Bourbonnais, ILBuilt 2011 · S/N 587N850KJAggie Aviation LLC · Buna, TXBuilt 2013 · S/N 659N850KKK-T Industries Inc · Sheldon, IABuilt 2008 · S/N 438N850KPOak Tree Ventures LLC · Verona, WIBuilt 2008 · S/N 476N850KTDearing Michael P · Anderson, TXBuilt 2010 · S/N 566N850LCOales Aviation Inc · Wilmington, DEBuilt 2011 · S/N 582N850LDAluna Corp Trustee · Wilmington, DEBuilt 2007 · S/N 417N850LEKey 511 Inc Trustee · Wilmington, DES/N 511N850LHLiton Services Inc Trustee · Wilmington, DEBuilt 2006 · S/N 374N850LLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 350N850LMMansfield Aviation International LLC · Wilmington, DEBuilt 2010 · S/N 538N850LTSelby Ryan · Sunriver, ORBuilt 2011 · S/N 585N850MBMavair LLC · Santa Fe, NMBuilt 2009 · S/N 506N850MFD'Offay LLC · San Francisco, CABuilt 2008 · S/N 459N850MKAviara Leasing LLC · Reston, VABuilt 2007 · S/N 403N850MRKsd-7 LLC · Sublimity, ORBuilt 2012 · S/N 612N850MWHampton Blue LLC · Dover, DEBuilt 2007 · S/N 408N850MYGreen Doors LLC · Lake Charles, LABuilt 2008 · S/N 478N850PARf Aviation LLC · Owensboro, KYBuilt 2009 · S/N 510N850PCPyramid Aviation LLC · Heber, CABuilt 2013 · S/N 652N850PDN850pd LLC · Oklahoma City, OKBuilt 2008 · S/N 485N850PFNethery Cattle Co LLC · Fort Worth, TXBuilt 2010 · S/N 570N850PKShelton Aviation II LLC · Apex, NCBuilt 2006 · S/N 375N850PRCharlie Tango LLC · Rapid City, SDS/N 426N850PTBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 398N850PWKazakh Kid LLC · Charlottesville, VABuilt 2007 · S/N 390N850RBLease Holdings LLC · Henderson, NVBuilt 2009 · S/N 524N850RLValiair Limited Co Trustee · Casper, WYBuilt 2007 · S/N 413N850RPWest East Bay Aviation LLC · Weston, MABuilt 2012 · S/N 616N850SBMagic Carpet Two LLC · Harwinton, CTBuilt 2006 · S/N 357N850SCSpur Creek LLC · Savannah, GABuilt 2008 · S/N 481N850SFAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 495N850SJAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 447N850TASpencer Jackson Holdings LLC · Denver, COBuilt 2010 · S/N 542N850TBDelta Ag Aviation LLC · Missoula, MTBuilt 2006 · S/N 346N850TJJ&M Travels LLC · Baton Rouge, LABuilt 2010 · S/N 568N850TPPj Capital LLC · Clearbrook, MNBuilt 2012 · S/N 620N850TSWestern Farming LLC · Missoula, MTBuilt 2012 · S/N 640N850TTMco Aviation LLC · Atkinson, NEBuilt 2008 · S/N 470N850TVAd Pilot LLC · Frisco, TXBuilt 2009 · S/N 513N850TXBlanco Resources LLC · Dover, DEBuilt 2006 · S/N 368
Back to AD 2007-03-17 R1