Skip to content

Registered aircraft · 447

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

N602KWAlta 767 Spv LLC · Salt Lake City, UTBuilt 1985 · S/N 23306 N603KWAlta 767 Spv LLC · Salt Lake City, UTBuilt 1985 · S/N 23213 N604KWAlta 767 Spv LLC · Salt Lake City, UTBuilt 1988 · S/N 24145 N605KWAlta 767 Spv LLC · Salt Lake City, UTBuilt 1984 · S/N 23180 N606KWAlta 767 Spv LLC · Salt Lake City, UTS/N 24324 N607AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30573 N613AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30574 N617AZAmazon.Com Services LLC · Seattle, WABuilt 2001 · S/N 30575 N619AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30594 N625HRTryst 767 LLC · San Juan, PRBuilt 1992 · S/N 25287 N641AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30595 N641UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25091 N642UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25092 N643AZAmazon.Com Services LLC · Seattle, WABuilt 2001 · S/N 32776 N643UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25093 N644UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25094 N645GTAtlas Air Inc · Purchase, NYBuilt 1995 · S/N 27393 N646UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25283 N647UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25284 N648UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25285 N649UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25286 N650GTUmb Bank N A Trustee · Salt Lake City, UTBuilt 1982 · S/N 22566 N651UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25389 N652GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 1983 · S/N 22571 N652UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25390 N653UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25391 N654UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25392 N655UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25393 N656GTJetran LLC · Horseshoe Bay, TXBuilt 1984 · S/N 23017 N656UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 25394 N657GTJetran LLC · Horseshoe Bay, TXBuilt 1984 · S/N 23018 N657UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27112 N658UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27113 N659GTJetran LLC · Horseshoe Bay, TXBuilt 1984 · S/N 23140 N659UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27114 N66051United Airlines Inc · Chicago, ILBuilt 2000 · S/N 29446 N66056United Airlines Inc · Chicago, ILBuilt 2001 · S/N 29451 N66057United Airlines Inc · Chicago, ILBuilt 2002 · S/N 29452 N660UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27115 N661AZAmazon.Com Services LLC · Seattle, WAS/N 29384 N661UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27158 N662UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27159 N663GTAtlas Air Inc · Purchase, NYBuilt 1995 · S/N 27568 N663UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27160 N664UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 29236 N665UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 29237 N666UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 29238 N667UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 29239 N668UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 30024 N669UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 30025

Back to AD 93-14-19 R1