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.

N280RKBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 2033N280RMStampede Aviation LLC · Tulsa, OKBuilt 2014 · S/N 2053N280RRLor 280 LLC · Atlanta, GABuilt 2020 · S/N 2201N280SSil-Con Air LLC · Delray Beach, FLBuilt 2019 · S/N 2185N280TDCook Canyon (Gp) LLC · Dallas, TXBuilt 2014 · S/N 2061N280TMRegistered aircraftBuilt 2018 · S/N 2167N280TTN280tt Partners LLC · San Mateo, CABuilt 2014 · S/N 2049N280WAWestern Two LLC · Phoenix, AZBuilt 2022 · S/N 2239N280WCWillliams Companies Inc · Tulsa, OKBuilt 2021 · S/N 2232N280WSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 2200N280XYRegistered aircraftBuilt 2019 · S/N 2173N280YBYbp Aviation LLC · York, PABuilt 2024 · S/N 2284N281BRN19br LLC · Alden, IABuilt 2023 · S/N 2263N281CECummins Inc · Columbus, INBuilt 2022 · S/N 2243N281FXFlexjet LLC · Cleveland, OHBuilt 2026 · S/N 55010214N281HLHrl Enterprises LLC · Charlotte, NCBuilt 2023 · S/N 2258N281MWSchweitzer Aircraft Leasing Inc · Pullman, WABuilt 2020 · S/N 2209N281RHWinnepeg LLC · West Palm Beach, FLBuilt 2020 · S/N 2217N281WCWilliams Companies Inc · Tulsa, OKBuilt 2024 · S/N 2294N282CECummins Inc · Columbus, INBuilt 2023 · S/N 2259N282JDRegistered aircraftBuilt 2019 · S/N 2193N282QAQuanta Services Inc · Houston, TXBuilt 2014 · S/N 2052N282QSCmbh Holdings LLC · Oklahoma City, OKBuilt 2025 · S/N 55010187N28357Csc Delaware Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 2022N283BRanger Air LLC · Kinston, NCBuilt 2008 · S/N 20252N283BATvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2015 · S/N 2090N283CECummins Inc · Columbus, INBuilt 2021 · S/N 2226N283QSRegistered aircraftBuilt 2025 · S/N 55010188N284CXSummit Air Innovative Solutions LLC · Phoenix, AZBuilt 2025 · S/N 2309N284MWSchweitzer Aircraft Leasing Inc · Pullman, WABuilt 2020 · S/N 2210N284PCBanc Of America Leasing & Capital LLC · Riverside, RIBuilt 2020 · S/N 2208N284QSRegistered aircraftBuilt 2025 · S/N 55010190N284SEAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2017 · S/N 2115N285AFAflac Inc · Columbus, GABuilt 2018 · S/N 2155N285BABank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 2095N285EMExxon Mobil Corp · Houston, TXBuilt 2016 · S/N 2099N285QSRegistered aircraftBuilt 2026 · S/N 55010193N285TMRegistered aircraftBuilt 2019 · S/N 2174N286BANbi Holdings LLC · New Bremen, OHBuilt 2016 · S/N 2111N286JRTf 286 LLC · Torrance, CABuilt 2004 · S/N 20014N286MHPowerhouse Equipment Leasing LLC · Camden, DEBuilt 2013 · S/N 20400N286QSAst Financial LLC · Oklahoma City, OKBuilt 2026 · S/N 55010195N287QS2024 Aviation LLC · Oklahoma City, OKBuilt 2026 · S/N 55010198N287SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 2148N288QSArcflight LLC · Oklahoma City, OKBuilt 2026 · S/N 55010199N288SFPinnacle Bank · Columbus, GABuilt 2018 · S/N 55000085N289KSwagelok Manufacturing Co LLC · Highland Heights, OHBuilt 2020 · S/N 2219N289QSAmphenol Corp · Oklahoma City, OKBuilt 2026 · S/N 55010201N28ATBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 2296N28FEFederal Express Leasing Corp · Memphis, TNBuilt 2012 · S/N 20361
Back to AD 2018-04-13