AD 2011-06-10

Registered aircraft · 998

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

N26TGKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1999 · S/N 4636193N274CFair18 LLC · Montgomery, ALBuilt 2013 · S/N 4636578N276JKGfk Investments LLC · Saint Joseph, MIS/N 4636520N27RZHq Wings LLC · Porterville, CAS/N 4636299N2808LNtss LLC · Henderson, NVBuilt 2015 · S/N 4636676N280KCMccarty Anthony O · Saint Augustine, FLBuilt 1999 · S/N 4636219N280KTGetchell Investments LLC · Dallas, TXBuilt 2002 · S/N 4636329N283SSSmith Scott R · Grand Junction, COBuilt 1997 · S/N 4636080N286CMB&K Aircraft Leasing LLC · West Plains, MOBuilt 1986 · S/N 46-8608043N288TGSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2015 · S/N 4636682N28BRFlying Rock Aero LLC · Sunnyvale, CABuilt 1986 · S/N 468608045N28JKTorps LLC · Southlake, TXBuilt 1998 · S/N 4636164N28KYSoldo Joseph Peter · Chattanooga, TNBuilt 1984 · S/N 468508015N295SKds Aviation LLC · Normal, ILS/N 4636174N296PCCarlyle Air LLC · Morristown, TNBuilt 2008 · S/N 4692008N297CLivestock Health Products-Texas Inc · Dalhart, TXBuilt 2004 · S/N 4636359N297PMCentral City Aviation LLC · Carrington, NDBuilt 1997 · S/N 4636101N29KETj Air Holdings Inc Trustee · Wilmington, DEBuilt 2004 · S/N 4636352N302MMHidden Springs Aviation LLC · Perryville, KYBuilt 2008 · S/N 4692002N304LAK2 Sales LLC · Idaho Falls, IDS/N 4622033N306YSFlamingo Aircraft Holdings LLC · Orlando, FLBuilt 2024 · S/N 4636850N3095GLas Piedras LLC · Englewood, COBuilt 2008 · S/N 4692065N3098NValiair Lc Trustee · Casper, WYBuilt 2004 · S/N 4636357N309HWWolfe Rentals LLC · Milwaukie, ORBuilt 2013 · S/N 4636612N310BUTar Heel Aviation Inc · Bonita Springs, FLBuilt 1986 · S/N 4608004N310EMTc Aviation LLC · Atlanta, GABuilt 1988 · S/N 46-08109N311JFGrowers LLC · Mohall, NDS/N 4622039N311KFAlpha Papa LLC · Fort Stockton, TXBuilt 1999 · S/N 4636194N311LGCorporate Aviation Partners I LLC · Fort Worth, TXBuilt 2025 · S/N 4636866N3131MAir Service LLC · Wilmington, DEBuilt 2006 · S/N 4636382N3134FSignature Aviation Group LLC · Columbia, MOBuilt 2012 · S/N 4692183N314PLWkj Enterprises LLC · Boulder, COBuilt 2011 · S/N 4636521N3151GMtc Aviation LLC · New Harmony, UTS/N 4636390N316KUOldenburg Air LLC · Henderson, NVBuilt 2005 · S/N 4636369N316TGTutton Group LLC · Jasper, GABuilt 2023 · S/N 4636832N317GCGospel Carrier International Inc · North Potomac, MDBuilt 2000 · S/N 4636292N318CWHeronimus Kevin A · Lebanon, TNBuilt 1998 · S/N 4636153N319RDN319rd LLC · Casa Grande, AZBuilt 1998 · S/N 4636139N319UWebb Automotive Group Inc · Farmington, NMBuilt 2015 · S/N 4636653N31BXWhite Robert · Woodlawn, TNBuilt 1986 · S/N 46-8608031N321AGLeo Air LLC · Marietta, OKBuilt 2012 · S/N 4636563N322MEMast Enterprises Equipment LLC · South Boston, VABuilt 1989 · S/N 4622064N323FLSch Aviation Inc Trustee · Sporle Kings LynnBuilt 1985 · S/N 468508096N325MRDv Group LLC · Clovis, CABuilt 2004 · S/N 4636358N327MZWdl/Oracle LLC · Tucson, AZBuilt 1998 · S/N 4636160N328EMConcierge Diamonds Inc · Los Angeles, CABuilt 1985 · S/N 46-8508087N329KSWings Flights Of Hope Inc · Orchard Park, NYBuilt 2013 · S/N 4636593N329TTJsh Aviation LLC · Dover, DEBuilt 2011 · S/N 4636513N330HTPhelan Dennis M · Goodyear, AZS/N 468408010N333GCDlx Rzl LLC · Rensselaer, INBuilt 2006 · S/N 4636383
Back to AD 2011-06-10