OpenAirDocs.org
AD 2012-06-01

Registered aircraft · 726

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:2012-06-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-06-01')
  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.

N560DTInsignia Capital Group Gp LLC · Walnut Creek, CABuilt 2007 · S/N 560-5675N560DXOrchid Island Aviation Inc · Daytona Beach, FLBuilt 2004 · S/N 560-5372N560ESPalmo Capital LLC · Dallas, TXBuilt 2008 · S/N 560-5800N560EXExelco Aviation LLC · Laredo, TXBuilt 2000 · S/N 560-5074N560GBSrj LLC · San Diego, CABuilt 2009 · S/N 560-6030N560GHQuality Leasing Inc · Niceville, FLBuilt 2008 · S/N 560-5755N560GJTennessee Valley Authority · Knoxville, TNBuilt 2015 · S/N 560-6186N560GKG Money LLC · Delavan, WIBuilt 2001 · S/N 560-5138N560GRGood Seven Management Plane Holdings LLC · Little Rock, ARBuilt 2015 · S/N 560-6203N560HN5437 Holdings LLC · Houston, TXBuilt 1998 · S/N 560-5015N560HXExcelevators LLC · Farmingdale, NYBuilt 2000 · S/N 560-5139N560JCFive Sixty Group LLC · Sheridan, WYFirst renewal noticeBuilt 2001 · S/N 560-5214N560JEDyad Aviation LLC · Solana Beach, CABuilt 2009 · S/N 560-6037N560KCN560kc LLC · Omaha, NEBuilt 2000 · S/N 560-5102N560KSAlva Acquisitions LLC · Arkadelphia, ARBuilt 2001 · S/N 560-5151N560LALee Aerospace Inc · Wichita, KSBuilt 2003 · S/N 560-5334N560LDCd Fl Management LLC · Crystal River, FLBuilt 2006 · S/N 560-5614N560LLBar Wr Air Services LLC · Dallas, TXBuilt 2000 · S/N 560-5104N560LSIbc Hospitality LLC · Newport Beach, CABuilt 2006 · S/N 560-5660N560LXLanier Equipment Leasing LLC · Gainesville, GABuilt 2007 · S/N 560-5726N560MCJem Air Holdings LLC · Raleigh, NCBuilt 2001 · S/N 560-5157N560MLMld Leasing LLC · Warsaw, INBuilt 1999 · S/N 560-5027N560NNovant Health Inc · Winston Salem, NCBuilt 2016 · S/N 560-6212N560PBDesert Aviation LLC · Kingman, AZS/N 560-6305N560PDAcs Air Investors LLC · Wilmington, DEBuilt 2003 · S/N 560-5311N560PGN560pg Xls LLC · Springfield, MOBuilt 2006 · S/N 560-5645N560PSPowersouth Energy Cooperative · Andalusia, ALBuilt 2013 · S/N 560-6146N560PVTah LLC · Papillion, NEBuilt 2006 · S/N 560-5610N560RNWrn Air LLC · Wilmington, DEBuilt 2001 · S/N 560-5212N560SCPalmetto Doodle LLC · Wilmington, DEBuilt 2014 · S/N 560-6161N560SGN560sg Leasing LLC · Wichita, KSBuilt 2002 · S/N 560-5308N560TDDwc Aircraft LLC · Dayton, OHBuilt 2007 · S/N 560-5711N560TKTdk Aviation LLC · Murfreesboro, TNBuilt 2014 · S/N 560-6167N560TNGolden Class Jet LLC · Fort Lauderdale, FLBuilt 2006 · S/N 560-5656N560TPPollard Aircraft Sales Inc · Fort Worth, TXBuilt 2001 · S/N 560-5217N560TVVerdoorn Daryl R Trustee · Saint Paul, MNBuilt 2005 · S/N 560-5545N560TWT W Lewis-Aviation LLC · Scottsdale, AZBuilt 2005 · S/N 560-5585N560VAUniversity Of Virginia Foundation · Charlottesville, VABuilt 2015 · S/N 560-6191N560VEDamco Holdings LLC · Houston, TXBuilt 2012 · S/N 560-6116N560VFVictor Foxtrot LLC · Scott City, KSBuilt 2000 · S/N 560-5135N560VSHillabrand Heir LLC · Greenville, SCBuilt 2000 · S/N 560-5066N560WBFirst National Bank · Paragould, ARBuilt 2008 · S/N 560-5764N560WG560wg LLC · Dover, DEBuilt 1999 · S/N 560-5028N560WLTres Amigos Aviation LLC · Dover, DEBuilt 1998 · S/N 560-5012N560XETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 560-5103N560XLTextron Aviation Inc · Wichita, KSBuilt 1995 · S/N 706N560ZFN560lj LLC · San Jose, CABuilt 2004 · S/N 560-5525N561BERegistered aircraftBuilt 2026 · S/N 560-6511N561JLFalcon Aviation Ltd Co · San Diego, CABuilt 2004 · S/N 560-5361N561PGTennessee Valley Authority · Chattanooga, TNBuilt 2017 · S/N 560-6225
Back to AD 2012-06-01