OpenAirDocs.org
AD 2020-26-12

Registered aircraft · 294

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

N100AKRegistered aircraftBuilt 2016 · S/N 2100N101GSG&S Aviation LLC · Richland, MSBuilt 2019 · S/N 2190N101XTXto Energy Inc · Houston, TXBuilt 2016 · S/N 2109N102PGPape Group Inc · Eugene, ORBuilt 2022 · S/N 2248N116NCNdc Equipment Leasing LLC · Lake Forest, ILBuilt 2021 · S/N 2221N117SFWildstar Partners LLC · Pittsford, NYBuilt 2022 · S/N 2249N1224MWilliams International Air Inc · Lancaster, NYBuilt 2013 · S/N 2031N125TRRaymond Corp · Greene, NYBuilt 2025 · S/N 2302N127SFConstellation Leasing LLC · Rochester, NYBuilt 2020 · S/N 2204N137GARegistered aircraftN-number assigned (import), not yet registeredS/N 2337N137SFConstellation Leasing LLC · Rochester, NYBuilt 2019 · S/N 2178N138GARegistered aircraftN-number assigned (import), not yet registeredS/N 2338N139GARegistered aircraftN-number assigned (import), not yet registeredS/N 2339N14GWRegistered aircraftBuilt 2023 · S/N 2264N1580Jpair LLC · New York, NYBuilt 2013 · S/N 2019N15EWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 2299N15TLTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2015 · S/N 2092N1620Cox Aviation LLC · Atlanta, GABuilt 2021 · S/N 2227N1640Cox Aviation LLC · Atlanta, GABuilt 2019 · S/N 2189N187SFWildstar Partners LLC · Pittsford, NYBuilt 2012 · S/N 2014N1980DJet Specialty Inc · Boerne, TXBuilt 2021 · S/N 2220N198HFHormel Foods Corporate Services LLC · Austin, MNBuilt 2019 · S/N 2176N199HFHormel Foods Corporate Services LLC · Austin, MNBuilt 2014 · S/N 2051N1FCTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 2079N1FGAdj 55 LLC · Woodcliff Lake, NJBuilt 2019 · S/N 2172N1FJRegistered aircraftS/N 2281N1JCN1jc Holdings LLC · West Long Branch, NJBuilt 2019 · S/N 2196N2025RRts Administrative Service Inc · Overland Park, KSBuilt 2025 · S/N 2303N202GAElectric Boat Corp · Groton, CTBuilt 2020 · S/N 2202N206FSCommerce Bank · Saint Louis, MOBuilt 2019 · S/N 2198N209FBTail Aviation LLC · Woburn, MABuilt 2013 · S/N 2018N210SFBnsf Equipment Acquisition Company LLC · Fort Worth, TXBuilt 2024 · S/N 2287N223GARegistered aircraftS/N 2323N22805Liqwd Inc · Santa Barbara, CABuilt 2019 · S/N 2184N228BARegistered aircraftBuilt 2016 · S/N 2103N228GAHoward Industries Inc · Ellisville, MSS/N 2328N229GABank Of Utah Trustee · Salt Lake City, UTS/N 2329N22SNSfw LLC · Las Vegas, NVBuilt 2023 · S/N 2275N232GAGulfstream Aerospace LLC · Savannah, GAS/N 2332N233GAGulfstream Aerospace LLC · Savannah, GAS/N 2333N235UBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 2214N236GAGulfstream Aerospace LLC · Savannah, GAS/N 2336N24GWRegistered aircraftBuilt 2022 · S/N 2257N259FGBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 2015N268PCBanc Of America Leasing & Capital LLC · Providence, RIS/N 2205N270PCBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 2137N280AFAflac Inc · Columbus, GABuilt 2017 · S/N 2129N280BLBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 2147N280BWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 2082N280CCca Holdings LLC · Richmond, VABuilt 2015 · S/N 2077
Back to AD 2020-26-12