Skip to content

Registered aircraft · 196

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

N437UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 25468 N438UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 25469 N439UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 25470 N440UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 25471 N441UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 27386 N442UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 27387 N443UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 27388 N444UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 27389 N446UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 27735 N447UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 27736 N448UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 27737 N449UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 27738 N450UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 25472 N451UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 27739 N452UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 25473 N454UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 25475 N455UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 25476 N456UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 25477 N457UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 25478 N458UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 25479 N459UPCc & Ei LLC · Louisville, KYBuilt 1996 · S/N 25480 N460UPC C & E I LLC · Louisville, KYBuilt 1996 · S/N 25481 N461UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 28265 N463UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 28267 N465UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 28269 N466UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 25482 N467UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 25483 N468UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 25484 N469UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 25485 N470UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 25486 N471UPUnited Parcel Service Co · Louisville, KYBuilt 1998 · S/N 28842 N472UPUnited Parcel Service Co · Louisville, KYBuilt 1998 · S/N 28843 N473UPUnited Parcel Service Co · Louisville, KYBuilt 1998 · S/N 28846 N474UPUnited Parcel Service Co · Louisville, KYBuilt 1999 · S/N 28844 N475UPUnited Parcel Service Co · Louisville, KYBuilt 1999 · S/N 28845 N48127United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28968 N507YVBank Of Utah Trustee · Salt Lake City, UTS/N 24607 N567CACascade Spares Inc · Knoxville, TNBuilt 1991 · S/N 24608 N56859United Airlines Inc · Chicago, ILBuilt 2004 · S/N 32818 N57111United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27301 N57852United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32811 N57855United Airlines Inc · Chicago, ILBuilt 2004 · S/N 32814 N57857United Airlines Inc · Chicago, ILBuilt 2004 · S/N 32816 N57862United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32586 N57863United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32587 N57864United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32588 N57869United Airlines Inc · Chicago, ILBuilt 2002 · S/N 32593 N57870United Airlines Inc · Chicago, ILBuilt 2003 · S/N 33525 N58101United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27291 N604AABischoff Aerospace Inc · Doral, FLBuilt 1995 · S/N 27055

Back to AD 86-15-01 R2