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.

N398WFOn Demand Aviation LLC · Port Orange, FLBuilt 2018 · S/N 4636734N39JEDuxbury Piper LLC · Duxbury, MABuilt 2010 · S/N 4636479N400TWJordy Sky Leasing LLC · Middletown, DEBuilt 1995 · S/N 4636015N402KCLazer Enterprises Ltd · Fargo, NDBuilt 2007 · S/N 4636420N405KCS H S Corporation · Indianola, IABuilt 1984 · S/N 46-8408044N408CAndonie Lourdes C · Mcallen, TXFirst renewal noticeBuilt 2006 · S/N 4636405N409CPHornowski Consulting Inc · Asheville, NCBuilt 2006 · S/N 4636375N40HPRock Communications LLC · Rock Hill, SCBuilt 2000 · S/N 4636264N40PMFlypie Industries LLC · Hudson, WIBuilt 1986 · S/N 4608005N40RZTwin Trails LLC · Draper, UTBuilt 1995 · S/N 4636009N40TSIst Solutions Inc · Los Angeles, CAFirst renewal noticeBuilt 2010 · S/N 4692156N410JCFbn Holding Corp · Larkspur, CABuilt 1986 · S/N 4608038N410STValiair Lc Trustee · Casper, WYBuilt 2007 · S/N 4636410N411MDJdr Inc · Cullman, ALBuilt 2000 · S/N 4636262N4121KMalibu Air LLC · Wilmington, DEBuilt 1998 · S/N 4636140N412BDWatts Keith · Lodi, CABuilt 2009 · S/N 4692115N4133GAmsg Transport LLC · Bloomfield Hills, MIBuilt 1998 · S/N 4636186N4139TMalibu Mirage Inc · Eugene, ORFirst renewal noticeBuilt 1998 · S/N 4636179N4141GPon Douglas James · Chalfont, PABuilt 1999 · S/N 4636233N41484Ferraro Jeffrey T · Mckinney, TXBuilt 1999 · S/N 4636234N4149RClary Daniela · Sunnyvale, TXBuilt 1999 · S/N 4636226N41518Lechene Craig · Holly Springs, NCBuilt 2000 · S/N 46-36302N4152DSires Brian · Cedar Falls, IABuilt 2000 · S/N 46-36304N41599Tiger Helicopters LLC · Baton Rouge, LABuilt 1999 · S/N 4636187N415DJAms Enterprises Capital Holdings Inc · Newark, DEBuilt 2016 · S/N 4636710N415VAVel-Air Inc · Clifton, VABuilt 2000 · S/N 4636290N415WRN415wr LLC · Bogart, GAS/N 4636147N415X3 Axis Aviation Inc Trustee · Wilmington, DEBuilt 2007 · S/N 4636425N4160NSteele Howard Scott · Idaho Falls, IDBuilt 2000 · S/N 4636280N4163PMalibu Aviation LLC · Bloomfield Hills, MIBuilt 2000 · S/N 4636274N41676American Roadways LLC · Missoula, MTBuilt 2000 · S/N 4636268N4167AWilliams Mirage LLC · Denver, COBuilt 2000 · S/N 46-36254N4167CSsp Aviation LLC · Aurora, OHBuilt 1999 · S/N 4636201N4175KYu Christopher · Menlo Park, CABuilt 2000 · S/N 4636294N41799Registration Pending · Panama City Beach, FLRegistration pendingBuilt 2000 · S/N 4636257N417JSCockapoo Air LLC · Naperville, ILBuilt 1998 · S/N 4636183N417MAT&G Aviation Services LLC · Temple, TXBuilt 2007 · S/N 4636415N417MXAw Foxtrot LLC · Cuero, TXBuilt 2008 · S/N 4692017N417RKAutavia Inc Trustee · Wilmington, DEBuilt 1999 · S/N 4636249N417STM500 LLC · Lewisville, TXBuilt 2017 · S/N 4636714N41874Tailwinds Leasing LLC · Missoula, MTBuilt 1999 · S/N 4636230N4188ASky Magic LLC · Helena, MTBuilt 2000 · S/N 4636296N4188DMachine Leasing · Kent, WABuilt 1999 · S/N 4636220N419MMRegistered aircraftBuilt 2008 · S/N 4692019N423JTSoutheast Air Tran LLC · Hahira, GABuilt 1994 · S/N 4622162N424JN424 Juliet LLC · Mesa, AZBuilt 1984 · S/N 46-8408019N425HNovak Matthew T · Dundee, ORS/N 4636288N426TC3di LLC · Elizabeth, WVBuilt 1987 · S/N 4622001N427ABSouthern Fabrication & Welding LLC · El Dorado, ARS/N 4636324N427WSMijares Miguel · Mcallen, TXBuilt 2001 · S/N 4636321
Back to AD 2011-06-10