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.

N91MJRightway Drywall Inc · Macon, GABuilt 2023 · S/N 50000441N924LGRg42 LLC · Plano, TXBuilt 2011 · S/N 50500057N925DRScout About LLC · Summerville, SCBuilt 2009 · S/N 50000059N925DT925dt LLC · Picayune, MSBuilt 2014 · S/N 50500212N925JDOtd Aviation LLC · Sterling, VABuilt 2018 · S/N 50500493N926JKR & S Aviation LLC · Menasha, WIBuilt 2009 · S/N 50000107N926JSN926js LLC · Garner, NCBuilt 2012 · S/N 50500078N929RTToonen Aviation LLC · Green Bay, WIBuilt 2010 · S/N 50500035N92DJInnovative Aviation LLC · Naples, FLBuilt 2022 · S/N 50500712N92WLWillis Lease Finance Corp · Larkspur, CABuilt 2016 · S/N 50500395N932DMTobin James Cellars · Klamath Falls, ORBuilt 2013 · S/N 50500142N932MAP100a LLC · Owensboro, KYBuilt 2009 · S/N 50000105N936EEN936ee LLC · Middletown, DEBuilt 2023 · S/N 50500786N941CEHermes Phenom LLC · Lakewood Ranch, FLBuilt 2021 · S/N 50500632N94MLQuarry Village Realty LLC · Denver, COBuilt 2025 · S/N 50500885N951EIvanov Aviation LLC · Wilsonville, ORBuilt 2021 · S/N 50500649N959BZElevate US LLC · Helena, MTBuilt 2018 · S/N 50000393N95HEPapa Joon LLC · Alexandria, VABuilt 2015 · S/N 50500288N95TGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 50500640N960RTDot Foods Inc · Mount Sterling, ILBuilt 2017 · S/N 50500413N962DMDmg Phenom I LLC · Miami, FLBuilt 2018 · S/N 50500477N963MWdr Holdings LLC · Tallahassee, FLBuilt 2010 · S/N 50000205N964MCertified Aviation LLC · Wilmington, DEBuilt 2011 · S/N 50000238N969GCAlt32 LLC · East Moline, ILBuilt 2014 · S/N 50500223N96AJRegistered aircraftBuilt 2023 · S/N 50500734N9714GHickory Aviation LLC · Adel, IABuilt 2021 · S/N 50500604N973SMBaker300 LLC · Danville, KYBuilt 2023 · S/N 50500727N974SCHorton Transportation Inc · Roseville, MNBuilt 2015 · S/N 50500282N976PWCf Aviation Trust LLC Trustee · Wilmington, DEBuilt 2024 · S/N 50500815N977JKKoehler Organization LLC · Aberdeen, SDBuilt 2018 · S/N 50500497N978PCPromega Corp · Fitchburg, WIS/N 50500330N97DATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 50500736N980JMs Aviation Services LLC · Jacksonville, FLBuilt 2015 · S/N 50000366N983CACitizen Jets 1 LLC · Port Angeles, WABuilt 2009 · S/N 50000029N985GFLets Geaux Flying LLC · Madisonville, LABuilt 2024 · S/N 50000454N988BCN988bc LLC · Vienna, VABuilt 2010 · S/N 50000139N991CATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 50000122N993GMNext Level Aviation LLC · Somerset, KYBuilt 2022 · S/N 50500695N993RSViceroy Venture Partners LLC · Key Biscayne, FLBuilt 2017 · S/N 50500421N9943RMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2017 · S/N 50500418N995JSJssi Parts LLC · Chicago, ILS/N 50500095N995LPCmi Logistics LLC · Pine Bluff, ARBuilt 2015 · S/N 50500321N995TMTcp Air III LLC · Enid, OKBuilt 2024 · S/N 50000453N996LCHighlands Air II LLC · Duluth, GABuilt 2015 · S/N 50500271N996SCMarrak LLC · Sergeant Bluff, IABuilt 2018 · S/N 50500494N998GCBlue Horizons Holdings LLC · Wilmington, DEBuilt 2010 · S/N 50500008N9990MAsher Consulting LLC · Gothenburg, NEBuilt 2010 · S/N 50000186N999BKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2026 · S/N 50500954
Back to AD 2021-24-21