Registered aircraft · 203

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

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-26-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-26-21') ORDER BY n_number

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-26-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-26-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.

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-26-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-26-21')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N243BCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 554 N244QCutter Flight Management Inc · Albuquerque, NMBuilt 2021 · S/N 214 N244UGogo Flight LLC · Broomfield, COBuilt 2020 · S/N 187 N244VAmerican Infrastructure Partners LLC · Whitefish, MTBuilt 2021 · S/N 252 N245GBBank Of Utah Trustee · Salt Lake City, UTBuilt 2026 · S/N 628 N245PCPilatus Aircraft USA Ltd · Broomfield, COS/N 643 N247EROnterris Response And Recovery LLC · North Little Rock, ARBuilt 2019 · S/N 152 N24JAArmstrong Airlines Inc · Dover, DES/N 637 N24PCOenovation LLC · Newberg, ORBuilt 2020 · S/N 185 N24SVFaith Technologies Inc · Menasha, WIBuilt 2024 · S/N 503 N24USGamma Sigma Alpha LLC · Hinsdale, ILBuilt 2024 · S/N 540 N24XBusiness Aircraft Corp · Wilmington, DEBuilt 2023 · S/N 302 N251AFCsmc Holdings Inc · Portsmouth, NHBuilt 2021 · S/N 251 N253DGBaja Aviation LLC · Livermore, CABuilt 2020 · S/N 171 N254PVSivu Transportation LLC · Anchorage, AKBuilt 2023 · S/N 316 N268PJAltwater Aviation LLC · Clinton, MTBuilt 2022 · S/N 268 N269AFRigi Inc · Portsmouth, NHBuilt 2022 · S/N 269 N271DJD&Tc LLC · Carlsbad, NMBuilt 2020 · S/N 162 N274AHCharlotte Mecklenburg Hospital Authority DBA · Charlotte, NCBuilt 2022 · S/N 274 N275SESoutheastern Freight Lines LLC · Lexington, SCBuilt 2026 · S/N 603 N276SESoutheastern Freight Lines LLC · Lexington, SCS/N 613 N277KEKlaton Transportation LLC · Topeka, KSBuilt 2022 · S/N 257 N279AHCharlotte-Mecklenburg Hospital Authority DBA · Charlotte, NCBuilt 2021 · S/N 219 N281EBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 160 N281NXCitizens National Bank Of Texas · Waxahachie, TXBuilt 2022 · S/N 281 N282AFStuart Hyundai LLC · Portsmouth, NHBuilt 2022 · S/N 282 N287CSSbma Services LLC · Beaverton, ORBuilt 2022 · S/N 287 N28GNRegistered aircraftS/N 604 N292AFJdwh LLC · Portsmouth, NHBuilt 2023 · S/N 292 N294AFSchwartz Eric S · Portsmouth, NHBuilt 2022 · S/N 294 N295GGGg 295 LLC · San Francisco, CABuilt 2022 · S/N 295 N298PCSierra Pacific Industries · Redding, CABuilt 2023 · S/N 298 N299AFRigi Inc · Portsmouth, NHBuilt 2023 · S/N 299 N29HAPlaza Car Wash Inc · Cape Girardeau, MOBuilt 2021 · S/N 250 N29MWWrdc Enterprise I LLC · Ardmore, PABuilt 2019 · S/N 136 N2CTPterodactyl LLC · Clawson, MIBuilt 2022 · S/N 289 N2PKCambridge Industries LLC · Rehoboth, MABuilt 2022 · S/N 276 N304DVDgv Family Properties LLC · Houston, TXBuilt 2023 · S/N 304 N327VBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 327 N330LGDelta Leasing LLC · Nashville, TNBuilt 2023 · S/N 330 N338TDWest Cirque LLC · San Francisco, CABuilt 2023 · S/N 323 N33GGreen Circle Projects Logistics LLC · Springfield, MOBuilt 2023 · S/N 296 N39TT39tt LLC · Lake Zurich, ILBuilt 2022 · S/N 256 N3LAAh Logistic Solutions LLC · Salt Lake City, UTBuilt 2026 · S/N 606 N400VJVenturejets124 LLC · Lititz, PABuilt 2019 · S/N 124 N405VJVj24 Assets LLC · Lititz, PABuilt 2019 · S/N 125 N40TXJewel 7-11 LLC · Bandera, TXS/N 618 N410RKDistributors Development Inc · Schofield, WIBuilt 2022 · S/N 259 N412MHMfh Aviation LLC · Boise, IDBuilt 2023 · S/N 332 N412RKDistributors Development Inc · Schofield, WIBuilt 2023 · S/N 324

Back to AD 2021-26-21