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.

N194MGSdw Aviation LLC · Albany, GABuilt 1999 · S/N 525-0357N1957NAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2024 · S/N 525-1182N195MFHat*Trick Holdings LLC · Buchanan, MIBuilt 1995 · S/N 525-0110N196JHSab Holdings LLC · Allen, TXBuilt 2012 · S/N 525B0395N196PCPapercone Aviation LLC · Louisville, KYBuilt 2008 · S/N 525B-0231N198PPAwp Aviation LLC · Lewes, DEBuilt 2023 · S/N 525B0711N19DPMonterey Bay LLC · Atlanta, GABuilt 1993 · S/N 525-0040N19RCTequila Flights LLC · Maple Grove, MNBuilt 2016 · S/N 525-0919N1BZL2 Operations LLC · Saint Paul, MNBuilt 2001 · S/N 525-0439N1CEMoose Ventures LLC · Palo Alto, CABuilt 2015 · S/N 525B0481N1FMCokelet LLC · South Padre Island, TXBuilt 1997 · S/N 525-0218N1HRays Leasing LLC · Hobe Sound, FLBuilt 2005 · S/N 525B0055N1LFFuzzell Aviation LLC · Hoover, ALBuilt 2011 · S/N 525B0359N1MWWilcox Jet Logistics LLC · Toledo, OHBuilt 2010 · S/N 525B0351N1RDDuncan Aviation Inc · Lincoln, NEBuilt 2019 · S/N 525B0586N1ULUrschelair Leasing LLC · Chesterton, INBuilt 2022 · S/N 525B0683N2006MTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 525B0563N200FTBbk Partners LLC · York, PABuilt 2014 · S/N 525A-0200N200SLAtfo LLC · Wildwood, MOBuilt 2001 · S/N 525-0461N201MCN201mc LLC · Raleigh, NCBuilt 2007 · S/N 525B-0141N201RCRcc Management & Aviation LLC · Magnolia, TXBuilt 2001 · S/N 525A0043N204JCentral Beach LLC · El Paso, TXBuilt 1996 · S/N 525-0164N205TCCarpenter Aviation LLC · Northport, ALBuilt 1994 · S/N 525-0050N205YYLittle H Holdings LLC · Piqua, OHBuilt 2004 · S/N 525A0205N207BGSteel Jet LLC · Carlsbad, CABuilt 2006 · S/N 525A-0326N207MMMmg Insurance Co · Presque Isle, MEBuilt 2002 · S/N 525A0084N208BGRobinson Manufacturing Co · Dayton, TNBuilt 2008 · S/N 525A0414N20DCKar Aviation LLC · New Albany, MSS/N 5250208N20SGN20sg LLC · Key Colony Beach, FLBuilt 2006 · S/N 525B0075N20VLRusken Packaging Inc · Cullman, ALBuilt 1994 · S/N 525-0069N210MBSafe Flight LLC · Suwanee, GABuilt 1997 · S/N 525-0211N211DBAmerican Aviation Inc · Gallatin, TNBuilt 2017 · S/N 525B0533N211MLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 525B-0211N212RHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 525-0636N2131Black Dogs Aviation LLC · Columbus, INBuilt 2009 · S/N 525B0297N213FRoni 1 LLC · Sacramento, CABuilt 2007 · S/N 525B0184N213JTLake Air Sale LLC · Wilmington, DEBuilt 2002 · S/N 525-0492N213PCPerryman Co · Houston, PABuilt 2025 · S/N 525B0901N215RBGolden Eagle Aviation Lc · Orlando, FLBuilt 2005 · S/N 525A0243N216SCGp Aviation LLC · Morristown, NJBuilt 2025 · S/N 525B0746N216TMColorado Jet LLC · Englewood, COBuilt 2012 · S/N 525B0387N219CMMt Aviation LLC · Cincinnati, OHBuilt 2001 · S/N 525A0045N219HFAugusta Air II LLC · Fayetteville, NCBuilt 2016 · S/N 525-0907N21GVNpda LLC · Kansas City, MOBuilt 2009 · S/N 525B0301N21RATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 525A-0092N21TKMtk Leasing LLC · Woodburn, ORS/N 525-0131N21VCCitation Hawk LLC · Moody, ALBuilt 1995 · S/N 525-0106N21VUTiara Air II LLC · Naples, FLBuilt 2017 · S/N 525B0529N220ARAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2005 · S/N 525B0029N220JLJuliet Charlie LLC · Wolf Creek, MTS/N 525-0020
Back to AD 2019-08-13