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.

N222JMOld Well Aviation LLC · Charlotte, NCBuilt 1995 · S/N 525-0116N222NFShelter Air Charter LLC · Brooklyn, NYBuilt 2002 · S/N 525A-0074N222TCCase Coal Sales LLC · Louisa, KYBuilt 2017 · S/N 525-0960N222VRHp Transportation LLC · Phoenix, AZBuilt 2007 · S/N 525B0155N222VVJbi Holding LLC · Madison, WIBuilt 2008 · S/N 525B0233N223CFCbel Aviation Inc · Macon, GABuilt 2000 · S/N 525-0403N223JFJettair LLC · Dallas, TXBuilt 1997 · S/N 525-0223N224CJEagle Aviation LLC · Hamel, MNBuilt 1997 · S/N 525-0224N225DWGulf South Management Inc · Destin, FLBuilt 2026 · S/N 525B0908N225SCRhode Jason · Austin, TXBuilt 2020 · S/N 525B0611N22LXMarcelo Christian Demaria Inc · Dover, DEBuilt 2011 · S/N 525A0477N22SDodson International Parts Inc · Rantoul, KSBuilt 2014 · S/N 525-0842N232BWNoram Aviation LLC · Tulsa, OKBuilt 2022 · S/N 525-1109N232HCTlhmrb LLC · Midway, FLBuilt 2022 · S/N 525B0667N233TJCorsair Two LLC · Hillsboro, ORBuilt 2017 · S/N 525B0525N237MPA7cj2 LLC · Greensboro, NCBuilt 2003 · S/N 525A0179N238RMSacj LLC · San Antonio, TXBuilt 2009 · S/N 525A0453N23BKBig Sky Leasing LLC · Madison, WIBuilt 1997 · S/N 525-0198N23PSRfl Equipment LLC · Colorado Springs, COBuilt 2023 · S/N 525B0713N23YTVision X LLC · Chattanooga, TNBuilt 2026 · S/N 525-1408N241CJBeam 33 Inc · Billings, MTBuilt 2008 · S/N 525B0241N2424JStratosphere Asset Management LLC · New Hampton, IAS/N 525B0925N242BSDm Aviation LLC · Lexington, SCBuilt 1997 · S/N 525-0230N242KVEvv Air LLC · Missoula, MTBuilt 2008 · S/N 525B0242N242LMHeritage Logistics LLC · Holdrege, NEBuilt 2017 · S/N 525-0970N242PGPage Aviation LLC · Saint Louis, MOBuilt 2018 · S/N 525-0993N242RFOwsley Robert L · Anchorage, AKBuilt 1998 · S/N 525-0294N242SDBinette Alan · Medford, ORBuilt 2020 · S/N 525-1069N246ESFlight Services Inc · St Thomas, VIBuilt 2023 · S/N 525-1161N246GLBonanza Management LLC · Newark, DEBuilt 2001 · S/N 525-0446N247BGCornerstone Air LLC · Wilmington, DEBuilt 2026 · S/N 525B0906N248KGJetnexa Two LLC · Gilbert, AZBuilt 2015 · S/N 525B0483N248PMCourtney Inc · Irvine, CABuilt 2016 · S/N 525B0494N248RFStaff Air Group Inc Trustee · Wilmington, DEBuilt 2004 · S/N 525A-0199N248SEM7 Leasing LLC · Seattle, WABuilt 2020 · S/N 525B0608N249CALafayette Flight Service LLC · Broussard, LABuilt 1998 · S/N 525-0291N24HNLafayette Transit LLC · Danville, KYBuilt 2021 · S/N 525B0635N24UGNorthern Jet Management Inc · Grand Rapids, MIBuilt 2019 · S/N 525B0577N24XPOlive Organization LLC · El Paso, TXBuilt 2019 · S/N 525-1023N251GMJrjgc Investments LLC · Saltillo, MSBuilt 2015 · S/N 525-0895N251KDBusiness Aviation LLC · Springfield, MOBuilt 2002 · S/N 525A0133N252JKLow Country 525 LLC · Charleston, SCBuilt 1996 · S/N 525-0166N252RVHssj LLC · Chattanooga, TNBuilt 1998 · S/N 5250252N253CWRegistered aircraftBuilt 1998 · S/N 525-0253N256JBBlossman Gas Of North Carolina Inc · Swannanoa, NCBuilt 1998 · S/N 525-0284N257HCartam Air LLC · San Antonio, TXBuilt 2007 · S/N 525B0162N25BGSpearfish LLC · St Peters, MOBuilt 2000 · S/N 525-0363N25DLTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 525-1419N25LZTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2003 · S/N 525A0177N25PJPjs Aviation LLC · Dunn, NCBuilt 2006 · S/N 525-0607
Back to AD 2019-08-13