AD 2023-06-13

Registered aircraft · 138

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:2023-06-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:2023-06-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.

N750TEU S Bank Na · Marshall, MNBuilt 2025 · S/N 70224N752AVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 70016N754GPWestend Az LLC · Phoenix, AZBuilt 2025 · S/N 70229N755AJCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2022 · S/N 70114N75CRSuper Blue Moon LLC · Lewes, DEBuilt 2025 · S/N 70225N773JLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 70211N783KFRegistered aircraftN-number assigned (import), not yet registeredS/N 70283N787FZ7500 LLC · East Granby, CTBuilt 2023 · S/N 70155N807LATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 70065N80MVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 70201N810KJRise & Shine Air LLC · Wilmington, DEBuilt 2019 · S/N 70015N818BAAc Logistics LLC · Salt Lake City, UTBuilt 2020 · S/N 70018N830EMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 70170N83JJLiautaud Development Group LLC-Global Series · Franklin, TNS/N 70261N86RSBombardier Aerospace Corp · Dallas, TXS/N 70264N875RMCp17 LLC · Cohoes, NYBuilt 2023 · S/N 70144N885AQAcg 6000 LLC · New York, NYBuilt 2020 · S/N 70008N885AWRegistered aircraftN-number assigned (import), not yet registeredS/N 70280N888GXBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 70036N889DXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2026 · S/N 70251N88CTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 70099N88FEBank Of Utah Trustee · Salt Lake City, UTBuilt 2025 · S/N 70222N88LTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 70156N890BDRegistered aircraftBuilt 2020 · S/N 70046N893BDRegistered aircraftN-number assigned (import), not yet registeredS/N 70082N898MJGh4 Partners LLC · Cohoes, NYBuilt 2023 · S/N 70161N899STBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 70078N8AKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 70168N8LATrey Aviation LLC · Naples, FLBuilt 2026 · S/N 70267N907TFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 70159N916MMBombardier Aerospace Corp · Dallas, TXS/N 70276N919FGN919fg LLC · Urbana, ILBuilt 2019 · S/N 70025N928GGOur Angel Wingz LLC · Salt Lake City, UTBuilt 2023 · S/N 70141N955JSMjmm Ventures LLC · Las Vegas, NVBuilt 2022 · S/N 70121N97DQDuquesne Global LLC · New York, NYBuilt 2020 · S/N 70051N980GGMaple Seven LLC · New York, NYBuilt 2022 · S/N 70130N988DXRegistered aircraftBuilt 2020 · S/N 70073N998RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 70019
Back to AD 2023-06-13