Skip to content

AD 2016-15-01 R1

Registered aircraft · 124

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:2016-15-01-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:2016-15-01-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:2016-15-01-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:2016-15-01-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:2016-15-01-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:2016-15-01-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.

N173UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0868 N174UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0869 N430FEFederal Express Corp · Memphis, TNBuilt 1985 · S/N 394 N431FEFederal Express Corp · Memphis, TNBuilt 1984 · S/N 316 N453FEFederal Express Corp · Memphis, TNBuilt 1983 · S/N 267 N454FEFederal Express Corp · Memphis, TNBuilt 1983 · S/N 278 N650FEFederal Express Corp · Memphis, TNBuilt 1993 · S/N 726 N651FEFederal Express Corporation · Memphis, TNBuilt 1994 · S/N 728 N652FEFederal Express Corp · Memphis, TNBuilt 1994 · S/N 735 N653FEFederal Express Corp · Memphis, TNBuilt 1994 · S/N 736 N654FEFederal Express Corp · Memphis, TNBuilt 1994 · S/N 738 N655FEFederal Express Corp · Memphis, TNBuilt 1994 · S/N 742 N656FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 745 N657FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 748 N658FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 752 N659FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 757 N660FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 759 N661FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 760 N662FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 761 N663FEFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 766 N664FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 768 N665FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 769 N667FEFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 771 N668FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 772 N669FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 774 N670FEFederal Express Corp · Memphis, TNBuilt 1997 · S/N 777 N671FEFederal Express Corp · Memphis, TNBuilt 1997 · S/N 778 N672FEFederal Express Corp · Memphis, TNBuilt 1997 · S/N 779 N673FEFederal Express Corp · Memphis, TNBuilt 1997 · S/N 780 N674FEFederal Express Corp · Memphis, TNBuilt 1997 · S/N 781 N675FEFederal Express Corporation · Memphis, TNBuilt 1998 · S/N 789 N676FEFederal Express Corp · Memphis, TNBuilt 1998 · S/N 790 N677FEFederal Express Corp · Memphis, TNBuilt 1998 · S/N 791 N678FEFederal Express Corp · Memphis, TNBuilt 1998 · S/N 792 N679FEFederal Express Corp · Memphis, TNBuilt 1998 · S/N 793 N680FEFederal Express Corp · Memphis, TNBuilt 1998 · S/N 794 N681FEFederal Express Corporation · Memphis, TNBuilt 1999 · S/N 0799 N682FEFederal Express Corp · Memphis, TNBuilt 1999 · S/N 0800 N683FEFederal Express Corp · Memphis, TNBuilt 1999 · S/N 0801 N684FEFederal Express Corp · Memphis, TNBuilt 1999 · S/N 0802 N685FEFederal Express Corp · Memphis, TNBuilt 1999 · S/N 0803 N686FEFederal Express Corp · Memphis, TNBuilt 1999 · S/N 0804 N687FEFederal Express Corp · Memphis, TNBuilt 2007 · S/N 0873 N688FEFederal Express Corp · Memphis, TNBuilt 2007 · S/N 0874 N689FEFederal Express Corp · Memphis, TNBuilt 2007 · S/N 0875 N690FEFederal Express Corp · Memphis, TNBuilt 2007 · S/N 0876 N691FEFederal Express Corp · Memphis, TNBuilt 2007 · S/N 0877 N692FEFederal Express Corp · Memphis, TNBuilt 2007 · S/N 0878 N717FDFederal Express Corp · Memphis, TNBuilt 1987 · S/N 361 N719FDFederal Express Corp · Memphis, TNBuilt 1989 · S/N 388

Back to AD 2016-15-01 R1