Skip to content

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.

N27XPRavello LLC · Tulsa, OKBuilt 2015 · S/N 50000348 N282GSMississippi Queen Partners LLC · Naples, FLBuilt 2011 · S/N 50500041 N282TXTransmedics Inc · Belgrade, MTBuilt 2021 · S/N 50500607 N283CPCommerical Bag Company · Bloomington, ILBuilt 2025 · S/N 50500870 N283TXTransmedics Inc · Belgrade, MTBuilt 2021 · S/N 50500626 N284TXTransmedics Inc · Belgrade, MTBuilt 2022 · S/N 50500660 N285GCDelaware Aviation LLC · Dover, DEBuilt 2012 · S/N 50000285 N285TXTransmedics Inc · Belgrade, MTBuilt 2023 · S/N 50500714 N287STProtyme LLC · Wilmington, DEBuilt 2018 · S/N 50000404 N287TXTransmedics Inc · Belgrade, MTBuilt 2023 · S/N 50500749 N288DXQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 2010 · S/N 50000166 N289RZSpire Aviation II LLC · Mooresville, NCBuilt 2012 · S/N 50000289 N289TXTransmedics Inc · Belgrade, MTBuilt 2022 · S/N 50500687 N290TXTransmedics Inc · Belgrade, MTBuilt 2023 · S/N 50500750 N291TXTransmedics Inc · Belgrade, MTBuilt 2023 · S/N 50500759 N292TXTransmedics Inc · Belgrade, MTBuilt 2023 · S/N 50500781 N293CKM&M Aircraft Group LLC · Aurora, ILBuilt 2022 · S/N 50500701 N293TXTransmedics Inc · Belgrade, MTBuilt 2024 · S/N 50500769 N294TXTransmedics Inc · Belgrade, MTBuilt 2023 · S/N 50500745 N295TXTransmedics Inc · Belgrade, MTBuilt 2023 · S/N 50500784 N297TXTransmedics Inc · Belgrade, MTBuilt 2022 · S/N 50500692 N298TXTransmedics Inc · Belgrade, MTBuilt 2023 · S/N 50500722 N299PPCastle Aviation II LLC · Meridian, MSBuilt 2015 · S/N 50500298 N29GSAir Cashmere LLC · Granger, INBuilt 2014 · S/N 50500240 N300DPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 50500573 N300EEPhenom Flight Operations LLC · Marion, INBuilt 2020 · S/N 50500537 N300EZAvex Xi LLC · Fort Lauderdale, FLS/N 50500794 N300FJRichbuilt Construction LLC · Fort Pierce, FLBuilt 2011 · S/N 50500046 N300FLValiair Lc Trustee · Casper, WYBuilt 2010 · S/N 50500027 N300FMTailwinds 300 LLC · Friendswood, TXBuilt 2024 · S/N 50500845 N300FPCapital Holdings 232 LLC · La Porte, INS/N 50500277 N300GMRosedale Aircraft LLC · Cedar Rapids, IABuilt 2012 · S/N 50500093 N300GVWheels Up Partners LLC · New York, NYBuilt 2012 · S/N 50500104 N300HJ300e LLC · Miami, FLBuilt 2024 · S/N 50500827 N300HYLgp Holding LLC · Chicago, ILBuilt 2014 · S/N 50500204 N300JKCerulean Advisory LLC · Houston, TXBuilt 2011 · S/N 50500073 N300LJAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2009 · S/N 50000021 N300MGEon Management LLC · Miami, FLBuilt 2012 · S/N 50500120 N300MWSolidfire Racing LLC · Kalispell, MTBuilt 2012 · S/N 50500101 N300QSRegistered aircraftBuilt 2016 · S/N 50500379 N300RXNorthside Hay Company Inc · Tempe, AZBuilt 2017 · S/N 50500420 N300ZZExecutive Airshare LLC · Overland Park, KSBuilt 2022 · S/N 50500663 N301AZPhenom 300 LLC · Fort Lauderdale, FLBuilt 2016 · S/N 50500377 N301BERegistered aircraftBuilt 2018 · S/N 50500464 N301FXPoirrier Sharon · Cleveland, OHBuilt 2024 · S/N 50500838 N301XTTub Time Aviation LLC · Portland, ORBuilt 2012 · S/N 50500096 N302AZPhenom 300 LLC · Fort Lauderdale, FLBuilt 2012 · S/N 50500130 N302FXRpc Strategies LLC · Cleveland, OHBuilt 2024 · S/N 50500839 N302MDDmgv Air LLC · Jonesboro, ARBuilt 2010 · S/N 50000203 N302QSRegistered aircraftBuilt 2013 · S/N 50500123

Back to AD 2021-24-21