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.

N330SAThree Feathers Logistics LLC · Atlanta, GABuilt 2013 · S/N 20413N330ZAMead Gregory Zane · Lubbock, TXBuilt 2004 · S/N 20035N332FXPinto Marc · Cleveland, OHBuilt 2023 · S/N 55010120N3337JBig Horns Leasing LLC · Jackson, WYBuilt 2011 · S/N 20337N333KHZzz Aviation LLC · Carlsbad, CABuilt 2016 · S/N 2094N334AFSusieair LLC · Houston, TXBuilt 2012 · S/N 20359N335AFArcadia Leasing LLC · Arcadia, WIS/N 20190N335FGN335fg LLC · Urbana, ILBuilt 2023 · S/N 20974N335FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 55010119N335REProampac Logistics LLC · North Hampton, NHBuilt 2020 · S/N 20858N336FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 55010118N337FXGabbert John · Cleveland, OHBuilt 2023 · S/N 55010116N338FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 55010114N338JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 20091N339BVAljobe Bajeky LLC · Levittown, NYBuilt 2011 · S/N 20328N339CMMmr West LLC · Salem, ORBuilt 2023 · S/N 20940N339FXTj Point LLC · Cleveland, OHBuilt 2023 · S/N 55010112N339TBJkdb Air LLC · Beaumont, TXBuilt 2018 · S/N 20743N33CHRitz Air LLC · Dayton, OHBuilt 2004 · S/N 20033N340FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 55010111N340JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 20109N342FXMansefeldt Investment Corp · Cleveland, OHBuilt 2023 · S/N 55010110N343FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 55010107N343JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 20518N345DXDsg Finance LLC · Coraopolis, PABuilt 2021 · S/N 2225N345FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 55010105N345HGAxios Aviation LLC · Traverse City, MIBuilt 2013 · S/N 20431N345WPBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2021 · S/N 2230N347FZZones Aircraft Leasing LLC · Bellevue, WABuilt 2017 · S/N 20681N347KKiewit Engineering Group Inc · Omaha, NEBuilt 2008 · S/N 20240N347NAUS Bank Na Trustee · Hartford, CTBuilt 2017 · S/N 2134N348BABillion Air LLC · Sioux Falls, SDBuilt 2019 · S/N 20782N349KKiewit Engineering Group Inc · Omaha, NEBuilt 2023 · S/N 20959N34GWRegistered aircraftBuilt 2022 · S/N 2250N34JMFlying Bullet LLC · Grand Island, NEBuilt 2014 · S/N 2055N350AJCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 20733N350ATRmf Horizon LLC · Syracuse, NYBuilt 2019 · S/N 20795N350CKSilver Britches Air LLC · Athens, GABuilt 2019 · S/N 20804N350HHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 20760N350HJLr60 296 Florida Holdings Inc · Coral Gables, FLBuilt 2014 · S/N 20504N350JRKatz Aviation Holdings LLC · Pompano Beach, FLBuilt 2020 · S/N 20856N350KHAmerican Builders & Contractors Supply Co Inc · Beloit, WIBuilt 2020 · S/N 20845N350KMCarolina Air Transfer II LLC · Alpharetta, GABuilt 2014 · S/N 20505N350KRMmr West LLC · Salem, ORBuilt 2019 · S/N 20808N350LMBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 55000031N350LTDohertys Toys Second LLC · Lakeland, FLBuilt 2017 · S/N 20685N350LY350 Lear Yankee Partners LLC · Chesterfield, MOBuilt 2019 · S/N 20820N350MBRockwell Collins Leasing LLC · Cedar Rapids, IABuilt 2014 · S/N 20531N350NPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 20794N350PDBrighid Air LLC · Farmingdale, NYBuilt 2016 · S/N 20611
Back to AD 2018-04-13