OpenAirDocs.org
AD 2021-24-21

Registered aircraft · 898

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:2021-24-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2021-24-21')
  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.

N400EPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 50000340N400JAJetaviva LLC · Overland Park, KSBuilt 2014 · S/N 50500206N400QFLisha Investments LLC · Beverly Hills, CABuilt 2009 · S/N 50000026N400QSEcovery LLC · Oklahoma City, OKBuilt 2026 · S/N 50500920N401QSCity Service Air Holdings LLC · Oklahoma City, OKBuilt 2026 · S/N 50500923N402QSRegistered aircraftBuilt 2016 · S/N 50500389N403QSBig Air LLC · Oklahoma City, OKBuilt 2026 · S/N 50500926N404QSRegistered aircraftBuilt 2017 · S/N 50500401N405QSAbundant Aviation Holdings LLC · Oklahoma City, OKBuilt 2026 · S/N 50500930N406QSRegistered aircraftBuilt 2017 · S/N 50500402N407QSRegistered aircraftBuilt 2017 · S/N 50500405N408QSRegistered aircraftBuilt 2017 · S/N 50500408N409KGKen Garff Automotive LLC · Salt Lake City, UTBuilt 2022 · S/N 50500696N409QSRegistered aircraftBuilt 2017 · S/N 50500431N40RCVivo Volare LLC · Santa Barbara, CAS/N 50500562N410MZokaites Frank R Trustee · Wexford, PABuilt 2023 · S/N 50500739N410QSRegistered aircraftBuilt 2017 · S/N 50500427N411LDAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2017 · S/N 50500411N411QSRegistered aircraftBuilt 2017 · S/N 50500432N412NNicholas Services LLC · Oxford, MSBuilt 2018 · S/N 50500454N412QSRegistered aircraftBuilt 2017 · S/N 50500440N413QSRegistered aircraftBuilt 2026 · S/N 50500937N414CBP300a LLC · Owensboro, KYBuilt 2016 · S/N 50500374N414QSNetjets Sales Inc · Oklahoma City, OKBuilt 2017 · S/N 50500441N416QSRegistered aircraftBuilt 2017 · S/N 50500443N417N567852 LLC · Virginia Beach, VABuilt 2021 · S/N 50500638N417QSRegistered aircraftBuilt 2017 · S/N 50500444N418QSRegistered aircraftBuilt 2018 · S/N 50500452N419CTDf Aviation LLC · Somerset, KYBuilt 2025 · S/N 50500889N419MAMaxair LLC · Oshkosh, WIBuilt 2010 · S/N 50500019N419NNicholas Services LLC · Oxford, MSBuilt 2020 · S/N 50500583N419PJAircraft One LLC · Sarasota, FLBuilt 2015 · S/N 50500281N419QSRegistered aircraftBuilt 2018 · S/N 50500461N41AAApplied Imaging Ride LLC · Grand Rapids, MIBuilt 2017 · S/N 50500422N420QSRegistered aircraftBuilt 2018 · S/N 50500462N420TJTp Aviation LLC · Salt Lake City, UTBuilt 2014 · S/N 50500228N421AJEmpire Airlines Inc · Lebanon, MOBuilt 2009 · S/N 50000015N421MBiltmark Transportation Inc · Wilmington, NCBuilt 2018 · S/N 50500490N422QSRegistered aircraftBuilt 2018 · S/N 50500467N422RSSsi Diagnostics LLC · Stuart, FLBuilt 2022 · S/N 50500677N423NDlp Real Estate Capital Inc · Saint Augustine, FLBuilt 2012 · S/N 50500125N423QSRegistered aircraftBuilt 2018 · S/N 50500468N424QSRegistered aircraftBuilt 2018 · S/N 50500470N425QSRegistered aircraftBuilt 2026 · S/N 50500953N426JAJem Aviation II LLC · Thomasville, NCBuilt 2025 · S/N 50500884N426QSRegistered aircraftBuilt 2018 · S/N 50500483N427QSRegistered aircraftBuilt 2018 · S/N 50500484N428KDover Aviation LLC · Baton Rouge, LABuilt 2020 · S/N 50500579N428QSRegistered aircraftBuilt 2018 · S/N 50500485N429QSRegistered aircraftBuilt 2019 · S/N 50500486
Back to AD 2021-24-21