AD 2018-04-13

Registered aircraft · 1,373

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-04-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-04-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.

N28GLKre8 Escapes LLC · Burlington, NJBuilt 2011 · S/N 2004N28GPGenuine Parts Co · Atlanta, GABuilt 2015 · S/N 2089N28VEValero Services Inc · San Antonio, TXBuilt 2024 · S/N 2290N290CHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 20029N290CLJs Leasing LLC · Frisco, TXBuilt 2009 · S/N 20290N293HCHampton Cattle Co LLC · Orlando, FLBuilt 2011 · S/N 20330N295QSExamworks LLC · Oklahoma City, OKBuilt 2026 · S/N 55010211N296QSRegistered aircraftBuilt 2026 · S/N 55010215N297BARegistered aircraftBuilt 2022 · S/N 2237N299SCRegistered aircraftBuilt 2023 · S/N 2260N299TSTsi Equipment Leasing LLC · Spokane, WABuilt 2011 · S/N 20316N29GPPnc Bank Na · Boise, IDBuilt 2016 · S/N 2110N29HGTractor & Equipment Co · Tukwila, WABuilt 2019 · S/N 20817N29PFPi International LLC · Sacramento, CABuilt 2021 · S/N 55020130N2HLHl Aircraft LLC · Oklahoma City, OKBuilt 2016 · S/N 20631N2LMaltese Journeys 280 LLC · Dover, DEBuilt 2015 · S/N 2074N2XTRb171 LLC · Wilmington, DEBuilt 2023 · S/N 20938N300JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 20115N300KCKroger Co · Cincinnati, OHBuilt 2012 · S/N 20385N300KEOneok Inc · Tulsa, OKBuilt 2011 · S/N 20336N300KHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 20130N300LVCapital Challenge LLC · Reno, NVBuilt 2006 · S/N 20129N300NJFrazier Aviation LLC · Corpus Christi, TXBuilt 2004 · S/N 20013N300NZTvpx Ars Inc Trustee · Concord, MABuilt 2013 · S/N 20397N300RRegistered aircraftBuilt 2025 · S/N 2310N300RLBbl Aviation LLC · Scottsdale, AZBuilt 2006 · S/N 20090N300TUFlying Amici Aviation LLC · Owasso, OKBuilt 2009 · S/N 20264N301JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 20162N301JLRegistered aircraftBuilt 2012 · S/N 20351N301WMAngel Air LLC · Sheridan, WYBuilt 2013 · S/N 2028N302JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 20321N302KCorporate Jet Leasing Co LLC · Wichita, KSBuilt 2009 · S/N 20267N302KCKroger Co · Cincinnati, OHBuilt 2013 · S/N 20389N302LTAsig Aviation Partners LLC · Dover, DEBuilt 2007 · S/N 20157N302PEBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 20144N302WMN824sm LLC · Tallahassee, FLBuilt 2013 · S/N 2029N303JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 20320N303XTXto Energy Inc · Houston, TXBuilt 2017 · S/N 2116N304KCKroger Co · Cincinnati, OHBuilt 2013 · S/N 20390N304RJHaystack Jmr LLC · Irvine, CABuilt 2008 · S/N 20243N305DLWilbur & Orville Inc · Wyoming, MIBuilt 2016 · S/N 20608N305WMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 20379N306MFUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 20009N306WBJ & R Airways LLC · Lincoln, ALBuilt 2004 · S/N 20015N307HRSeminole Tribe Of Florida DBA · Davie, FLBuilt 2016 · S/N 2098N307JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 20123N307JWFinch Lawrence G · Moraga, CABuilt 2006 · S/N 20093N308JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 20218N308KBBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 2068N308MJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2026 · S/N 55020253
Back to AD 2018-04-13