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.

N349FXFlexjet LLC · Cleveland, OHBuilt 2012 · S/N 50500100 N351FXFlexjet LLC · Cleveland, OHBuilt 2012 · S/N 50500105 N351QSRegistered aircraftBuilt 2014 · S/N 50500237 N352DZDel Zotto International LLC · Ocala, FLBuilt 2017 · S/N 50500396 N352FXFlexjet LLC · Cleveland, OHBuilt 2012 · S/N 50500109 N352QSRegistered aircraftBuilt 2014 · S/N 50500244 N353FXFlexjet LLC · Cleveland, OHBuilt 2012 · S/N 50500115 N353QSRegistered aircraftBuilt 2014 · S/N 50500263 N353SBEasy Jet LLC · Menifee, CABuilt 2009 · S/N 50000038 N354FXFlexjet LLC · Cleveland, OHBuilt 2013 · S/N 50500135 N354PSTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2026 · S/N 50500967 N354QSRegistered aircraftBuilt 2014 · S/N 50500265 N355FXFlexjet LLC · Cleveland, OHBuilt 2013 · S/N 50500139 N356BHHoffman Leasing LLC · Andrews, TXBuilt 2016 · S/N 50500333 N356FXFlexjet LLC · Cleveland, OHBuilt 2013 · S/N 50500155 N356GRsg Aviation LLC · Park City, UTBuilt 2022 · S/N 50500676 N356NNicholas Services LLC DBA · Oxford, MSBuilt 2014 · S/N 50000335 N357FXFlexjet LLC · Cleveland, OHBuilt 2014 · S/N 50500156 N358EEAerodyne Flight Services LLC · Merritt Island, FLBuilt 2022 · S/N 50500658 N358FXFlexjet LLC · Cleveland, OHBuilt 2014 · S/N 50500171 N359AKEmbraer Executive Aircraft Inc · Melbourne, FLS/N 50500981 N359ASExecutive Airshare LLC · Overland Park, KSS/N 50500354 N359FXFlexjet LLC · Cleveland, OHBuilt 2014 · S/N 50500208 N35EABank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2018 · S/N 50500495 N360FXFlexjet LLC · Cleveland, OHBuilt 2014 · S/N 50500233 N360QSRegistered aircraftBuilt 2015 · S/N 50500254 N361ASExecutive Airshare LLC · Overland Park, KSS/N 50500313 N361FXFlexjet LLC · Cleveland, OHBuilt 2014 · S/N 50500234 N362ASExecutive Airshare LLC · Overland Park, KSBuilt 2016 · S/N 50500368 N363FWRegistered aircraftBuilt 2014 · S/N 50500242 N363FXFlexjet LLC · Cleveland, OHBuilt 2016 · S/N 50500390 N363QSRegistered aircraftBuilt 2015 · S/N 50500256 N364FXFlexjet LLC · Cleveland, OHBuilt 2012 · S/N 50500133 N365FXFlexjet LLC · Cleveland, OHBuilt 2015 · S/N 50500269 N365PFStraightline Properties LLC · Houston, TXBuilt 2016 · S/N 50000365 N366FXFlexjet LLC · Cleveland, OHS/N 50500326 N366QSRegistered aircraftBuilt 2015 · S/N 50500268 N367ERJetscape Business Aviation LLC · Fort Lauderdale, FLBuilt 2010 · S/N 50000159 N367FXFlexjet LLC · Cleveland, OHBuilt 2016 · S/N 50500378 N367QSRegistered aircraftBuilt 2015 · S/N 50500273 N368ASExecutive Airshare LLC · Lenexa, KSBuilt 2015 · S/N 50500341 N368FXFlexjet LLC · Cleveland, OHBuilt 2016 · S/N 50500380 N369AXAtaraxia Aircraft Holdings LLC · Greenville, SCBuilt 2011 · S/N 50000214 N369FXFlexjet LLC · Cleveland, OHBuilt 2016 · S/N 50500382 N370FXFlexjet LLC · Cleveland, OHBuilt 2016 · S/N 50500384 N371FXFlexjet LLC · Cleveland, OHBuilt 2016 · S/N 50500387 N371QSRegistered aircraftBuilt 2015 · S/N 50500279 N371VABank Of Utah Trustee · Salt Lake City, UTS/N 50000371 N372FXFlexjet LLC · Cleveland, OHBuilt 2016 · S/N 50500388 N373EEBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 50500731

Back to AD 2021-24-21