Skip to content

Registered aircraft · 105

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

N10180Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N C139 N104MDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N C135 N118PAPhoenix Air Group Inc · Cartersville, GABuilt 1989 · S/N 151 N185KJJah 2022a Saab340b Msn 185 LLC · Dallas, TXBuilt 1990 · S/N 340B-185 N189EHBristow LLC · Lake Charles, LABuilt 2015 · S/N 49018 N189PAPhoenix Air Group Inc · Cartersville, GABuilt 1985 · S/N 038 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 N252QAQuality Aviation LLC · Boulder, COBuilt 2004 · S/N C-145 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 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 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 N313AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-313 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 N352CJAviation Inventory Resources Inc · Alvarado, TXBuilt 1993 · S/N 340B-352 N353SABank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N 340B-351 N361CLLegends Cargo Aircraft LLC · Lakeland, FLBuilt 1994 · S/N 340B-361 N362AGJahn362ag LLC · Miami, FLBuilt 1998 · S/N 340B-438 N364PXFloat Alaska Holdings LLC · Pomona, CAS/N 340B-262 N369PXAviation Inventory Resources Inc · Alvarado, TXS/N 340B-295 N383ECAeronave Corp · Kalispell, MTBuilt 2007 · S/N C-177 N385RSAeronave Corp · Kalispell, MTBuilt 1991 · S/N C-042 N390ALBank Of Utah Trustee · Salt Lake City, UTBuilt 1990 · S/N 28198 N391ALBank Of Utah Trustee · Salt Lake City, UTS/N 28103

Back to AD 2018-03-13