AD 2019-08-13

Registered aircraft · 1,554

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:2019-08-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:2019-08-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.

N300HFMorgan Aviation Leasing LLC · Knoxville, TNBuilt 2011 · S/N 525B0363N300JWAviate LLC · Greensboro, NCBuilt 2023 · S/N 525B0695N300MVMaverik Inc · Salt Lake City, UTBuilt 2007 · S/N 525B0148N302CJN302cj LLC · Springfield, MOBuilt 2006 · S/N 525A0302N302JKCrt Air LLC · Mentor, OHBuilt 2016 · S/N 525B0493N303KMCoastal Rentals LLC · Allen, KYBuilt 2000 · S/N 525-0180N304BPIntermountain Air Inc · Colorado Springs, COBuilt 2019 · S/N 525-1017N304TCCanyons Aviation Group LLC · Orlando, FLBuilt 2015 · S/N 525B0478N304TXNlw Inc DBA · Indianapolis, INBuilt 2018 · S/N 525B0569N305KCRegistered aircraftBuilt 2021 · S/N 525B0636N306CJRegistered aircraftBuilt 2001 · S/N 525A-0016N307LJJd One Third LLC · Houston, TXBuilt 2008 · S/N 525B0279N307PEN307pe LLC · Irvine, CABuilt 2008 · S/N 525B0254N308CMCattlemen Logistics LLC · Minden, NEBuilt 2023 · S/N 525-1156N308GTSan Joaquin Refining Co Inc · Bakersfield, CABuilt 2008 · S/N 525B0236N308NJ22ase LLC · Aspen, COS/N 525-0912N309CJJe Air LLC · Byron Center, MIBuilt 2006 · S/N 525A0309N30BPLkh Group LLC · Naples, FLBuilt 2014 · S/N 525-0816N30CJR K B Inc · Portland, ORBuilt 2024 · S/N 525B0730N30DESunskies Aviation LLC · Bakersfield, CABuilt 2007 · S/N 525B0185N30GXBell Avenue Aviation LLC · Des Moines, IABuilt 2019 · S/N 525B0594N30KMRefreshed 0110 LLC · Dover, DEBuilt 2021 · S/N 525-1073N30LAAerokb LLC · Wilmington, DEBuilt 1993 · S/N 5250041N30MSkysouth Aviation Inc · Durham, NCBuilt 2003 · S/N 525-0506N30NMTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 525-1420N30NSHilltop LLC · Rye, NYBuilt 2014 · S/N 525-0835N30STStreet Aviation LLC · Naples, FLBuilt 2012 · S/N 525A0497N30VRWd Journeys Inc · Downers Grove, ILBuilt 2002 · S/N 5250481N310EGWhite Pine Two LLC · Park City, UTBuilt 2006 · S/N 525B0067N310GTGt Carriers Aircraft LLC · Bakersfield, CABuilt 2002 · S/N 525A-0086N311CPKwihnai Flyers LLC · Troy, OHBuilt 2024 · S/N 525-1165N311SRIsr Aviation LLC · Wilmington, DES/N 525-0172N313WLPeak Aviation LLC · Royal Oak, MIBuilt 2000 · S/N 525-0366N315CJFlagship Private Air LLC · Belleville, MIBuilt 2009 · S/N 525B0315N315HCHooper Holdings LLC · Madison, WIBuilt 2000 · S/N 525-0373N3168N3168 LLC · San Antonio, TXBuilt 2026 · S/N 525-1405N316BDM2mo LLC · Saint Louis, MOBuilt 2009 · S/N 525B0316N316PJWmj Aviation LLC · Wilmington, DEBuilt 2000 · S/N 525-0405N317TXRegistered aircraftBuilt 2010 · S/N 525B0340N318CGSvp LLC · Missoula, MTBuilt 1999 · S/N 525-0323N318JHAir Hoffmann LLC · Saint Louis, MOBuilt 2014 · S/N 525-0817N318JPSurric LLC · Shreveport, LABuilt 2024 · S/N 525-1174N319JDHollingsworth Intergalactic LLC · Clinton, TNBuilt 1997 · S/N 5250216N31CJ212 Investments Of Montana LLC · Collinsville, OKBuilt 2001 · S/N 525-0474N31HAHampden Aviation Services Inc · Florence, MABuilt 2014 · S/N 525-0829N31HDHotel Delta LLC · Sacramento, CABuilt 1998 · S/N 525-0261N31SPBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2015 · S/N 525-0874N31WEWorldwide Equipment Of Tn Inc · Knoxville, TNBuilt 2000 · S/N 5250362N320CJCeejay LLC · Parker, COBuilt 2006 · S/N 525B0120N321EMRiomar Sky LLC · Warrington, PABuilt 2023 · S/N 525-1152
Back to AD 2019-08-13