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

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

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.

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

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.

N168JCN168jc LLC · Wilmington, DEBuilt 2015 · S/N 50500334 N16MLBretoneus Ventures Inc · Tinmouth, VTBuilt 2011 · S/N 50500045 N16SJJk Leasing LLC · Gilbert, AZBuilt 2016 · S/N 50000369 N173GHClark Aviation LLC · Ashland, KYBuilt 2010 · S/N 50000173 N173PJR A N Air LLC · Atlanta, GABuilt 2013 · S/N 50500167 N175EM882 Aviation Inc · West Harrison, NYNon-citizen corporation, flight hours not reportedBuilt 2009 · S/N 50000106 N175EWN1235l LLC · Tallahassee, FLBuilt 2010 · S/N 50000188 N175MCAirex 3 LLC · Livonia, MIBuilt 2019 · S/N 50500526 N178CMTnka178 LLC · Boca Raton, FLBuilt 2010 · S/N 50000178 N17DBD&B Farmstand LLC · Hoboken, NJBuilt 2020 · S/N 50500566 N1873Koch Transportation LLC · Evansville, INBuilt 2021 · S/N 50500652 N1887BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 50500210 N188MRColumbia Collier Properties LLC · Naples, FLS/N 50000357 N188TMAeromerica LLC · Las Vegas, NVBuilt 2009 · S/N 50000124 N18MFAvion Zito II LLC · La Jolla, CABuilt 2025 · S/N 50500849 N18YPSpark Aviation LLC · West Harrison, NYBuilt 2008 · S/N 50000009 N190BWJjp Aviation LLC · Mobile, ALBuilt 2009 · S/N 50000028 N1920Perdue Farms Inc · Salisbury, MDBuilt 2021 · S/N 50500603 N1932MQt Asset 1 LLC · La Jolia, CABuilt 2024 · S/N 50500810 N1952RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 50500618 N1959N300 Aviation LLC · Lexington, KYBuilt 2018 · S/N 50500466 N199BAPhenom Acquisition LLC · New York, NYBuilt 2015 · S/N 50500290 N19SGBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 50000241 N1CHCmh Services Aviation Inc · Maryville, TNBuilt 2025 · S/N 50500888 N1KACmh Services Aviation Inc · Maryville, TNBuilt 2024 · S/N 50500818 N1MRN3818c Training LLC · Carrollton, TXBuilt 2019 · S/N 50500552 N1TXState Of Texas · Austin, TXBuilt 2019 · S/N 50000407 N1WBWeber Aviation Group LLC · Kenosha, WIBuilt 2010 · S/N 50000137 N1WCWc Air Transport LLC · Sevierville, TNS/N 50500555 N1WGWcm-1 LLC · Broomfield, COBuilt 2023 · S/N 50500733 N200Nuwest Builders Inc · Whitefish, MTBuilt 2009 · S/N 50000058 N203SSAircraft Holding And Leasing LLC · Sarasota, FLBuilt 2013 · S/N 50000293 N208DXAsa Parts LLC · Dallas, TXBuilt 2009 · S/N 50000097 N20FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 50500800 N20TQ8405 La LLC · Dallas, TXBuilt 2011 · S/N 50500044 N20XXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 50000281 N214PCFly Jpi LLC · Pittsburgh, PABuilt 2012 · S/N 50000298 N2152HHorton Transportation Inc · Roseville, MNBuilt 2015 · S/N 50500274 N216TXTransmedics Inc · Belgrade, MTBuilt 2024 · S/N 50500807 N218RGPtaryndactyl LLC · Indianapolis, INBuilt 2010 · S/N 50000172 N21DQAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2018 · S/N 50000395 N21SBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 50000154 N221EMTtt Flyers LLC · South Bend, INBuilt 2009 · S/N 50000025 N222KBRegistered aircraftBuilt 2021 · S/N 50500605 N222KZWarrior Notes · Destrehan, LABuilt 2013 · S/N 50000302 N225ASRichelieu LLC · San Francisco, CABuilt 2011 · S/N 50000239 N225QTQuality Air Leasing LLC · St George, UTBuilt 2025 · S/N 50500878 N226KVC2 Squared Consulting LLC · Port Orange, FLBuilt 2009 · S/N 50000071 N227SJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 50500723 N227SLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 50500305

Back to AD 2021-24-21