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.

N321RRambarran Brian D · Clarence Center, NYBuilt 1994 · S/N 525-0049N321SMLucky Stars LLC · Missoula, MTBuilt 2009 · S/N 525B0320N323ADShc Citation LLC · Jonesburg, MOBuilt 2002 · S/N 525A0124N323EZN323ez LLC · Amarillo, TXBuilt 1996 · S/N 525-0128N323SKMacd Capital LLC · Newark, DEBuilt 2002 · S/N 525A0134N324AMP & M Leasing Inc · Green Bay, WIBuilt 2022 · S/N 525B0672N324AVAvalair Aircraft Management LLC · Brookshire, TXBuilt 2010 · S/N 525B0347N324BDGodwin Aviation LLC · Dunn, NCBuilt 2008 · S/N 525-0674N325ATBtr Air Charter Cj LLC · Baton Rouge, LABuilt 2006 · S/N 525A0332N325GHBtr Air Charter Cj II LLC · Baton Rouge, LABuilt 2002 · S/N 525A0087N325MLWhen Pigs Fly Aviation LLC · Lawler, IABuilt 2009 · S/N 525A0458N325RCCharlie Bravo Leasing LLC · Chandler, AZBuilt 2005 · S/N 525B0021N325WCAlcjr LLC · Pataskala, OHBuilt 2025 · S/N 525B0753N326JKRiver Bank Aviation LLC · Dover, DEBuilt 2003 · S/N 525-0511N327TXLucky Devil LLC · Scottsdale, AZBuilt 2008 · S/N 525B0227N328CJRegistration Pending · College Grove, TNRegistration pendingBuilt 1999 · S/N 525-0328N329BHJos Aviation LLC · Conrad, IABuilt 2008 · S/N 525B0292N32ACAlliance Service Inc · Lexington, KYBuilt 2008 · S/N 525B0257N32BBGee Aviation Inc · Sturgis, KYBuilt 2019 · S/N 525-1026N330WSValiair Limited Co Trustee · Casper, WYBuilt 2006 · S/N 525B0066N331GGGed Jet LLC · Boca Raton, FLBuilt 1999 · S/N 525-0353N331MPMartins Famous Pastry Shoppe Inc · Chambersburg, PABuilt 2020 · S/N 525B0623N331PLPremier Aircraft Trading Service Inc · Lewes, DEBuilt 2002 · S/N 525A-0070N331XAJetnexa Three LLC · Gilbert, AZBuilt 2023 · S/N 525B0703N333BDFour Rings Aviation II LLC DBA · Gainesville, TXBuilt 2005 · S/N 525A0237N333SLT C Air LLC · West Linn, ORBuilt 2021 · S/N 525-1083N333XAJetnexa One LLC · Gilbert, AZBuilt 2015 · S/N 525-0889N335JJFlybiz LLC · Zeeland, MIBuilt 2003 · S/N 525A0162N33BKIronman LLC · Arlington, VABuilt 2017 · S/N 525B-0514N33BSIncomm Cj3 LLC · Atlanta, GABuilt 2025 · S/N 525B0763N33BWMecum Auction Inc · Walworth, WIS/N 525A0010N33DTN33dt LLC · Phoenix, AZBuilt 1995 · S/N 525-0080N33FWNext Level Aviation Group LLC · Sarasota, FLBuilt 1997 · S/N 525-0203N33NMBighorn Airways Inc · Sheridan, WYBuilt 1993 · S/N 5250025N33UMFirst Charter Service Corp · Ann Arbor, MIBuilt 2005 · S/N 525B0020N341ARMla Management LLC · Salt Lake City, UTBuilt 1999 · S/N 525-0341N341NLucky Stars LLC · Missoula, MTBuilt 2016 · S/N 525B-0485N345CJBrantigan Research LLC · Kalispell, MTBuilt 2002 · S/N 525A0136N346PAAb Jet Co Vi LLC · Metairie, LAS/N 525B0391N3478STrend Aviation LLC · Lafayette, LAS/N 525B0911N347BCRoni 1 LLC · Sacramento, CABuilt 2001 · S/N 525-0431N34RLKar2 Inc · Sevierville, TNBuilt 2017 · S/N 525-0948N34SJGamma2 Inc · San Marcos, CAS/N 525B-0197N34TCHuff Air LLC · Uvalde, TXBuilt 1994 · S/N 5250083N350BVDiane S Lake-Ca LLC · Bakersfield, CABuilt 2003 · S/N 525A0186N351AJR2 Enterprise Holdings LLC · Chandler, TXBuilt 2011 · S/N 525B0370N351BCInternational Bank Of Commerce · Laredo, TXBuilt 1996 · S/N 525-0159N351BFKbs Aviation LLC · Springboro, OHBuilt 2018 · S/N 525-0995N352AVAvalair Aircraft Management LLC · Brookshire, TXBuilt 2010 · S/N 525B0352N356DCZephyr Air LLC · Orlando, FLBuilt 2011 · S/N 525B0372
Back to AD 2019-08-13