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.

N789KGRps Air LLC · Bucyrus, KSBuilt 2005 · S/N 560-5538N78XLGarmin International Inc · Olathe, KSBuilt 2005 · S/N 560-5578N790TXEgret Flyers LLC · Winston Salem, NCBuilt 2008 · S/N 560-5790N798TAgeless Mens Health Holdings Inc · Scottsdale, AZBuilt 2003 · S/N 560-5307N7TMAeonian Air LLC · West Chester, PABuilt 2009 · S/N 560-6028N800AMReading And Northern Aviation Inc · Port Clinton, PABuilt 2001 · S/N 560-5195N800KVOnin Ascend LLC · Birmingham, ALBuilt 2012 · S/N 560-6104N801JSCitation 1 Juliet Sierra LLC · Uvalde, TXBuilt 2000 · S/N 560-5075N802TDAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 560-5153N803JSFe 5272 LLC · Kinston, NCS/N 560-5272N804BCClary Aviation LLC · Longview, WABuilt 2007 · S/N 560-5746N805BLShepair LLC · Virginia Beach, VABuilt 2011 · S/N 560-6088N806JS83 Aviation LLC · Fort Lauderdale, FLBuilt 2000 · S/N 560-5083N807JSDx Air Fleet LLC · Daytona Beach, FLBuilt 2003 · S/N 560-5354N808MNMilliken & Company · Greer, SCBuilt 2005 · S/N 560-5587N808SDDrillers Aviation LLC · Mt Morris, PABuilt 2017 · S/N 560-6234N809JSFe 5094 LLC · Kinston, NCS/N 560-5094N80AEAerocatalyst LLC · Detroit, MIBuilt 2019 · S/N 560-6276N80FDAma Freight LLC · Saint Clair Shores, MIBuilt 2002 · S/N 560-5225N80XAirxl LLC · Carmel, INBuilt 1999 · S/N 560-5054N810JBUnified Air Solutions LLC · Oldsmar, FLBuilt 2000 · S/N 560-5113N810JSAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2006 · S/N 560-5630N811CEArchie LLC · Hamilton, OHBuilt 2007 · S/N 560-5709N812BPDel Papa Holdings LLC · Beaumont, TXBuilt 2008 · S/N 560-6011N817BSAerodan Aviation LLC · Alpharetta, GABuilt 2000 · S/N 560-5106N817BZBrazos Aviation LLC · Fort Worth, TXBuilt 2007 · S/N 560-5742N817EGEng Capital LLC · Houston, TXBuilt 2001 · S/N 5605215N817LFPollard Aircraft Sales Inc · Fort Worth, TXBuilt 2001 · S/N 560-5150N818BLBrenmar Corp · Lawrenceville, GABuilt 2003 · S/N 560-5328N823JSAero Harbor Nc Ll · Charlotte, NCBuilt 2002 · S/N 560-5265N824JSFe 5536 LLC · Kinston, NCBuilt 2005 · S/N 5605536N827CRCamar Express LLC · Tallahassee, FLBuilt 2007 · S/N 560-5693N827DPN827dp LLC · Boyertown, PABuilt 2016 · S/N 560-6210N828DRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 560-5774N82GTTextron Financial Corp · Wichita, KSBuilt 2011 · S/N 560-6068N82HESummers-Taylor Inc · Johnson City, TNBuilt 2009 · S/N 560-6020N82KWRegistered aircraftBuilt 2011 · S/N 560-6094N830JGGlflights LLC · San Antonio, TXBuilt 2012 · S/N 560-6107N830JSRoss Advisors LLC · Naples, FLBuilt 2002 · S/N 560-5274N831GLFw Equipment Leasing LLC · Batesville, ARBuilt 2024 · S/N 560-6357N833JSFe 5107 LLC · Kinston, NCBuilt 2000 · S/N 5605107N835JSCt Equipment Leasing LLC · Kinston, NCBuilt 2008 · S/N 560-5813N836JSFe 5186 LLC · Kinston, NCBuilt 2001 · S/N 560-5186N837JSFe 5164 LLC · Kinston, NCBuilt 2001 · S/N 560-5164N838CBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 560-6164N838JSFe Encore Plus III LLC · Kinston, NCBuilt 2002 · S/N 560-5237N839JSRenflight LLC · Raleigh, NCBuilt 2004 · S/N 560-5356N83GBExcel 5 LLC · Columbus, GABuilt 2008 · S/N 560-5756N83LXLx Aviation LLC · Little Rock, ARBuilt 2024 · S/N 560-6354N83SPKelbel Aviation LLC · Longview, TXBuilt 2001 · S/N 560-5202
Back to AD 2012-06-01