Skip to content

Registered aircraft · 523

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:2020-03-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:2020-03-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:2020-03-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:2020-03-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:2020-03-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:2020-03-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.

N2QEBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 9629 N2TN2t Inc · Hillsboro, ORBuilt 2005 · S/N 9162 N300SCSn 9184 LLC · Fort Lauderdale, FLBuilt 2006 · S/N 9184 N302AKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 9436 N306MASc Aviation LLC · Austin, TXBuilt 2007 · S/N 9225 N307MALive Holdings A1 LLC · Windermere, FLBuilt 2013 · S/N 9550 N311NBCisco Aero - N9410 LLC · Cisco, TXBuilt 2010 · S/N 9410 N311RRGlobal 5500 LLC · San Diego, CABuilt 2022 · S/N 60065 N312AFBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 9551 N313BKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 9108 N313RFWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 9194 N318CEWonderous Air LLC · New York, NYBuilt 2026 · S/N 60220 N318GFTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2023 · S/N 60092 N319GGGg Aviation LLC · San Luis Obispo, CABuilt 2000 · S/N 9070 N3208Bombardier Aerospace Corp · Dallas, TXBuilt 2026 · S/N 60206 N321VCRegistered aircraftBuilt 2009 · S/N 9339 N321WAWinchester Air Inc · Winchester, MABuilt 2018 · S/N 9852 N325CBRegistered aircraftBuilt 2019 · S/N 9866 N3262TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 9254 N326GXKelgen Partnership Llp · Milwaukee, WIBuilt 2009 · S/N 9326 N330KCRegistered aircraftBuilt 2013 · S/N 9579 N343DFBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 9702 N343EL94t LLC · Cheyenne, WYBuilt 2022 · S/N 60048 N34681Registered aircraftBuilt 2014 · S/N 9634 N348BDRegistered aircraftN-number assigned (import), not yet registeredS/N 60248 N351LSCombined Aircraft Ownership LLC · Fargo, NDBuilt 2000 · S/N 9050 N360HPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 9344 N3618KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 9449 N365CJTashi Corp · Oakland, CABuilt 2000 · S/N 9077 N36MMJags Leasing LLC · Piscataway, NJBuilt 2007 · S/N 9244 N372BCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 9413 N373GGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 9807 N373VBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 9420 N375WB9288 Corp Trustee · Wilmington, DEBuilt 2008 · S/N 9288 N378LTTvpx 2022 Msn 9218 Business Trust · North Salt Lake, UTBuilt 2006 · S/N 9218 N37LPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 9164 N3877821 393 LLC · Vienna, VABuilt 2008 · S/N 9304 N393BZFalcon Holdings II LLC · Teterboro, NJBuilt 2011 · S/N 9444 N393WJRegistered aircraftN-number assigned (import), not yet registeredS/N 60225 N394HHHawk Hollow Farm LLC · Brighton, MIBuilt 2005 · S/N 9161 N394WJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 9262 N3MRDouble Leasing LLC · Oxford, CTBuilt 2014 · S/N 9650 N3PCJuniper Aviation III LLC · Coral Gables, FLBuilt 2010 · S/N 9399 N400BCBall Corp · Broomfield, COBuilt 2013 · S/N 9573 N401VEBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 9320 N404NATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 9356 N40FPDnc Aircraft Holdings LLC · Wilmington, DEBuilt 2014 · S/N 9642 N40ZAHav Solutions LLC · Saint Petersburg, FLBuilt 2007 · S/N 9231 N410ATRegistered aircraftBuilt 2008 · S/N 9295 N411XTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 9133

Back to AD 2020-03-21