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.

N56CHCmh Homes Inc · Maryville, TNBuilt 2019 · S/N 55000081N570FXFlexjet LLC · Cleveland, OHBuilt 2014 · S/N 20527N571CHJet Resource Inc · Cincinnati, OHBuilt 2019 · S/N 2194N571FXFlexjet LLC · Cleveland, OHBuilt 2014 · S/N 20536N572FXFlexjet LLC · Cleveland, OHBuilt 2014 · S/N 20521N573FXFlexjet LLC · Cleveland, OHBuilt 2015 · S/N 20564N574FXFlexjet LLC · Cleveland, OHBuilt 2015 · S/N 20567N575FDEcho Acquisitions LLC · Dover, DEBuilt 2004 · S/N 20023N575FXFlexjet LLC · Cleveland, OHBuilt 2015 · S/N 20578N576FXFlexjet LLC · Cleveland, OHBuilt 2015 · S/N 20585N577FXFlexjet LLC · Cleveland, OHBuilt 2020 · S/N 20865N57810Palmer Square Capital Management LLC · Mission Woods, KSBuilt 2024 · S/N 21015N578FXFlexjet LLC · Cleveland, OHBuilt 2015 · S/N 20601N578XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 20078N579FXFlexjet LLC · Cleveland, OHBuilt 2016 · S/N 20647N580FXWheels Up Partners LLC · New York, NYBuilt 2016 · S/N 20652N581FXFlexjet LLC · Cleveland, OHBuilt 2016 · S/N 20657N582FXFlexjet LLC · Cleveland, OHBuilt 2017 · S/N 20701N583FXFlexjet LLC · Cleveland, OHBuilt 2017 · S/N 20703N583KDN583kd LLC · Cincinnati, OHBuilt 2025 · S/N 55020227N583TCU S Bank Na · Saint Paul, MNBuilt 2019 · S/N 55000083N584FXBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 20705N585AXCentury Mold Holdings LLC · Rochester, NYBuilt 2007 · S/N 20184N585FXFlexjet LLC · Cleveland, OHBuilt 2017 · S/N 20707N585PLRegistered aircraftBuilt 2018 · S/N 2164N586ALRegistered aircraftBuilt 2015 · S/N 20586N586DMMac Equipment Leasing LLC · Avondale, AZBuilt 2024 · S/N 2289N586FXFlexjet LLC · Cleveland, OHBuilt 2017 · S/N 20710N587DZRegistered aircraftBuilt 2019 · S/N 55020110N587FARegistered aircraftBuilt 2015 · S/N 20587N587FXFlexjet LLC · Cleveland, OHBuilt 2017 · S/N 20712N588FXFlexjet LLC · Cleveland, OHBuilt 2017 · S/N 20714N588KDN583kd LLC · Wilmington, DEBuilt 2016 · S/N 55010014N589FXFlexjet LLC · Cleveland, OHBuilt 2018 · S/N 20757N58CXCanon Aviation LLC · Sedalia, MOBuilt 2022 · S/N 2246N58HAAcrisure Aircraft N58ha LLC · New York, NYBuilt 2007 · S/N 20146N58LCAtlantic Excel LLC · San Marcos, CABuilt 2007 · S/N 20163N590CVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 20857N590MCRegistered aircraftBuilt 2004 · S/N 20027N593FXFlexjet LLC · Cleveland, OHBuilt 2019 · S/N 20819N594FXFlexjet LLC · Cleveland, OHBuilt 2019 · S/N 20821N595CBTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 20326N595FXFlexjet LLC · Cleveland, OHBuilt 2019 · S/N 20825N596FXFlexjet LLC · Cleveland, OHBuilt 2019 · S/N 20827N596LCHangar 39 LLC · Elkhart, INBuilt 2016 · S/N 20596N597FXFlexjet LLC · Cleveland, OHBuilt 2019 · S/N 20831N598DBHubble Horizons LLC · Meridian, IDBuilt 2020 · S/N 55020127N598FXFlexjet LLC · Cleveland, OHBuilt 2020 · S/N 20864N599FXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 20802N599JFLearjet Inc · Wichita, KSBuilt 2016 · S/N 20632
Back to AD 2018-04-13