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.

N392ALBank Of Utah Trustee · Salt Lake City, UTBuilt 1982 · S/N 28114 N392PHPhi Aviation LLC · Lafayette, LABuilt 2005 · S/N 920015 N393ALBank Of Utah Trustee · Salt Lake City, UTS/N 28117 N399CLBeta Fleet LLC · South Burlington, VTBuilt 1996 · S/N 340B-399 N413XJAviation Inventory Resources Inc · Alvarado, TXFirst renewal noticeBuilt 1997 · S/N 340B413 N417XJBank Of Utah Trustee · Salt Lake City, UTS/N 340B417 N419CLLegends Cargo Aircraft LLC · Lakeland, FLBuilt 1997 · S/N 340B-419 N431BCJahn431bc LLC · Miami, FLBuilt 1991 · S/N 340B-260 N432CLLegends Cargo Aircraft LLC · Lakeland, FLBuilt 1997 · S/N 340B-432 N440CLBank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 340B-440 N441FFAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1998 · S/N 340B441 N44KSGo Vector One LLC · Pls Vrds Est, CABuilt 1986 · S/N 340A-050 N458CLBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 340B-458 N481BCJahn481bc LLC · Miami, FLBuilt 1991 · S/N 340B-274 N492PHPhi Aviation LLC · Lafayette, LAS/N 920016 N503JWBristow LLC · Lake Charles, LABuilt 2016 · S/N 49025 N512EVBank Of Utah Trustee · Salt Lake City, UTBuilt 1983 · S/N 28115 N525BNBell Textron Inc · Fort Worth, TXBuilt 2016 · S/N 62003 N525BVBell Textron Inc · Fort Worth, TXBuilt 2018 · S/N 62014 N525TYBell Textron Inc · Fort Worth, TXBuilt 2019 · S/N 62015 N592PHPhi Aviation LLC · Lafayette, LAS/N 920027 N595QAQuality Aviation LLC · Boulder, COFirst renewal noticeBuilt 2004 · S/N C-143 N63AUTurbo Lease LLC · Miami, FLBuilt 1990 · S/N 340B-181 N641BCIbc Airways Inc · Fort Lauderdale, FLBuilt 1966 · S/N 340A069 N651BCAviation Inventory Resources Inc · Alvarado, TXS/N 340A-076 N671BCIbc Airways Inc · Fort Lauderdale, FLBuilt 1987 · S/N 340A-084 N675PAAviation Inventory Resources Inc · Alvarado, TXBuilt 1990 · S/N 340B-206 N677PAAviation Inventory Resources Inc · Alvarado, TXBuilt 1992 · S/N 340B-328 N681BCAviation Inventory Resources Inc · Alvarado, TXBuilt 1987 · S/N 340A-108 N685PAAviation Inventory Resources Inc · Alvarado, TXBuilt 1990 · S/N 340B-212 N69EKnight Helo LLC · Wilmington, DEBuilt 2005 · S/N 920009 N725HTBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 28128 N726HTBank Of Utah Trustee · Salt Lake City, UTBuilt 1988 · S/N 28196 N745HBank Of Utah Trustee · Salt Lake City, UTBuilt 1991 · S/N 28197 N746HBank Of Utah Trustee · Salt Lake City, UTBuilt 1991 · S/N 28200 N80AUAurora Flight Sciences Corp · Manassas, VABuilt 1998 · S/N 340B437 N822HBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 28139 N823HBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 28141 N825FAQflight Corp · Kalispell, MTBuilt 1998 · S/N C-130 N825HBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 28137 N835CEQflight Corp · Kalispell, MTBuilt 2007 · S/N C-176 N855PSVale Management Inc · Kalispell, MTBuilt 1990 · S/N C-030 N856PSVale Management Inc · Kalispell, MTBuilt 2008 · S/N C-182 N857PSVale Management Inc · Kalispell, MTBuilt 2009 · S/N C-186 N901BCAviation Inventory Resources Inc · Alvarado, TXBuilt 1987 · S/N 340A-088 N904AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-314 N907RARyan Air Inc · Anchorage, AKBuilt 1987 · S/N 340A-111 N931BCBank Of Utah Trustee · Salt Lake City, UTBuilt 1990 · S/N 340B-187 N951BCJah2022a Saab340b Msn 318 LLC · Dallas, TXBuilt 1992 · S/N 340B-318 N95SATurbo Lease LLC · Miami, FLS/N 340B-345

Back to AD 2018-03-13