Skip to content

Registered aircraft · 135

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:2017-19-20') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-19-20') 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:2017-19-20')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-19-20')
  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:2017-19-20')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-19-20')
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.

N104MDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N C135 N145JWBristow LLC · Lake Charles, LABuilt 2016 · S/N 920300 N185KJJah 2022a Saab340b Msn 185 LLC · Dallas, TXBuilt 1990 · S/N 340B-185 N189EHBristow LLC · Lake Charles, LABuilt 2015 · S/N 49018 N191ESTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 920120 N192ESTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 920130 N192PHPhi Aviation LLC · Lafayette, LABuilt 2005 · S/N 920021 N193ESTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 920162 N2100BBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 920089 N214EBBank Of Utah Trustee · Salt Lake City, UTS/N 28130 N219KABank Of Utah Trustee · Salt Lake City, UTBuilt 1990 · S/N 340B192 N220MJBank Of Utah Trustee · Salt Lake City, UTS/N 340B-220 N253AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-253 N265JAAviation Inventory Resources Inc · Alvarado, TXS/N 340B-265 N266AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-266 N267RFMsp Recovery Aviation LLC · Coral Gables, FLBuilt 2014 · S/N 920260 N275STBank Of Utah Trustee · Salt Lake City, UTS/N 28106 N277STBank Of Utah Trustee · Salt Lake City, UTS/N 28140 N27XJPhoenix Air Group Inc · Cartersville, GABuilt 1985 · S/N 340A-027 N286AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-286 N290BGBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 920219 N292MHChevron USA Inc · Picayune, MSBuilt 2013 · S/N 920204 N293BGBristow U.S. LLC · New Iberia, LABuilt 2013 · S/N 920221 N294TLAviation Inventory Resources Inc · Alvarado, TXBuilt 1997 · S/N 340B-294 N298AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-298 N304AEBank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N 340B-304 N304AGBank Of Utah Trustee · Salt Lake City, UTS/N 340B-418 N307AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-307 N3088UBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 920122 N309QTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 920309 N312ZCSikorsky Aircraft Corp · Owego, NYBuilt 2018 · S/N 920312 N313AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-313 N314RGRencopter 314 LLC · New York, NYBuilt 2009 · S/N 920109 N314SSBristow LLC · Lake Charles, LABuilt 2015 · S/N 49019 N3172Bank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N 340B172 N317AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-317 N320AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-320 N323AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-323 N326LSBristow LLC · Lake Charles, LABuilt 2016 · S/N 49028 N327AGBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 340B-427 N329AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-329 N331TBMassachusetts Institute Of Technology · Lexington, MABuilt 1992 · S/N 340B-331 N332AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-332 N336SABank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N 340B-336 N340RCConsumer Aviation Inc · Springfield, MOS/N 340B-340 N342JCAviation Investments Inc · Redondo Beach, CAS/N 340A-030 N346AGBank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 340B446 N346CJBank Of Utah Trustee · Salt Lake City, UTS/N 340B-346 N348AGAviation Inventory Resources Inc · Alvarado, TXBuilt 1998 · S/N 340B-448 N351AGBank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 340B445

Back to AD 2017-19-20