OpenAirDocs.org
AD 2018-07-13

Registered aircraft · 967

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

N361QSRegistered aircraftBuilt 2008 · S/N 680-0235N363APBelden Inc · Chesterfield, MOBuilt 2006 · S/N 680-0095N363HCMilligans Hurri-Clean LLC · Brewton, ALBuilt 2007 · S/N 510-0033N365JWJawco Aviation LLC · Jupiter, FLBuilt 2009 · S/N 510-0183N369FGFulgent Genetics Inc · Temple City, CABuilt 2008 · S/N 680-0255N369MUKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2011 · S/N 510-0369N36DPAbove The Timber LLC · Roseburg, ORBuilt 2011 · S/N 510-0391N36GBleu LLC · Wichita, KSBuilt 2009 · S/N 510-0243N370MKc Investments LLC · Fargo, NDBuilt 2011 · S/N 680-0307N371VPNap Holdings LLC · Hickory, NCBuilt 2011 · S/N 510-0371N372QSRegistered aircraftBuilt 2008 · S/N 680-0201N3765LTextron Aviation Inc · Wichita, KSBuilt 2014 · S/N E68A-719001N376QSRegistered aircraftBuilt 2007 · S/N 680-0180N376RSIas Air LLC · Shelley, IDBuilt 2004 · S/N 680-0009N377CM1kj LLC · Wilmington, DEBuilt 2013 · S/N 510-0445N377RVVandenberghe Construction Inc · Danville, CABuilt 2009 · S/N 510-0227N377TBGrove City Aviation LLC · Mercer, PABuilt 2008 · S/N 680-0187N378CM378 Mustang LLC · Tampa, FLBuilt 2011 · S/N 510-0378N387QSRegistered aircraftBuilt 2007 · S/N 680-0119N389QSRegistered aircraftBuilt 2007 · S/N 680-0149N392TBWeiswasser Jonathan M · Montclair, NJBuilt 2011 · S/N 510-0381N393JEJeb Investments LLC · Dublin, OHBuilt 2022 · S/N 680A0303N393KBRai Aviation LLC · Gallatin, TNBuilt 2016 · S/N 680A-0057N394CMCorsair Two LLC · Hillsboro, ORBuilt 2012 · S/N 510-0394N396BBBrown & Brown Inc · Daytona Beach, FLBuilt 2007 · S/N 680-0123N396QSRegistered aircraftBuilt 2008 · S/N 680-0240N397CMMustang Air LLC · Caledonia, MIBuilt 2012 · S/N 510-0397N397EGEthos Group Inc · Irving, TXBuilt 2016 · S/N 680A0039N39DSMt Hood Transport Inc · Fresno, CABuilt 2021 · S/N 680A0270N39EGIndel Services LLC · Rancocas, NJBuilt 2010 · S/N 510-0291N3TW3tw Aviation LLC · Austin, TXBuilt 2006 · S/N 680-0060N3ZCZachry Industrial Inc · San Antonio, TXBuilt 2012 · S/N 680-0346N401DERegistered aircraftS/N 510-0010N401MWQuattro Air Ventures LLC · Houston, TXBuilt 2006 · S/N 680-0112N404CZRaven Aircraft LLC · Prescott, AZBuilt 2012 · S/N 510-0404N404PLMaddie LLC · Saint Louis, MOBuilt 2013 · S/N 510-0442N404SPDjd Aero LLC · Lubbock, TXBuilt 2005 · S/N 680-0039N405PVPauls Valley Aviation LLC · Norman, OKBuilt 2009 · S/N 680-0265N405TRegistered aircraftBuilt 2020 · S/N 680A0254N406CMNet Lease Mgmt LLC · Scottsdale, AZBuilt 2007 · S/N 510-0015N408MBMb Mustang LLC · Piscataway, NJBuilt 2016 · S/N 510-0467N40FCBlue Mountain Sky LLC · Lafayette, LABuilt 2025 · S/N 680A0450N413CKAir Wolf LLC · Fremont, CABuilt 2006 · S/N 680-0064N416CMMedex LLC · Middleton, WIBuilt 2007 · S/N 510-0016N417AMDb Air LLC · Houston, TXBuilt 2007 · S/N 680-0137N420DPPfe Aviation LLC · Mandeville, LABuilt 2012 · S/N 680-0322N420KCKilocharlie Air LLC · Scottsdale, AZBuilt 2009 · S/N 510-0223N422BDNiss Aviation LLC · Ontario, OHBuilt 2019 · S/N 680A0191N422MLMvd Leasing LLC · Corona, CABuilt 2006 · S/N 680-0068N422TG422 Tg LLC · Miami Beach, FLBuilt 2012 · S/N 510-0429
Back to AD 2018-07-13