Skip to content

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:2017-08-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:2017-08-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:2017-08-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:2017-08-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:2017-08-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:2017-08-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.

N120UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 0805 N121UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 0806 N122UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 0807 N124UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 0808 N125UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 0809 N126UPC C & E I LLC · Louisville, KYBuilt 2000 · S/N 0810 N127UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 0811 N128UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0812 N129UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0813 N130UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0814 N131UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0815 N133UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0816 N134UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0817 N135UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0818 N136UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0819 N137UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0820 N138UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0821 N139UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0822 N140UPUnited Parcel Service Co · Louisville, KYBuilt 2002 · S/N 0823 N141UPUnited Parcel Service Co · Louisville, KYBuilt 2002 · S/N 0824 N142UPUnited Parcel Service Co · Louisville, KYBuilt 2002 · S/N 0825 N143UPUnited Parcel Service Co · Louisville, KYBuilt 2002 · S/N 0826 N144UPUnited Parcel Service Co · Louisville, KYBuilt 2002 · S/N 0827 N145UPUnited Parcel Service Co · Louisville, KYBuilt 2002 · S/N 0828 N146UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 829 N147UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 830 N148UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 0831 N149UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 832 N150UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 833 N151UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 834 N152UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 835 N153UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 0839 N154UPUnited Parcel Service Co · Louisville, KYBuilt 2004 · S/N 0840 N156UPUnited Parcel Service Co · Louisville, KYBuilt 2004 · S/N 0845 N157UPUnited Parcel Service Co · Louisville, KYBuilt 2004 · S/N 0846 N158UPUnited Parcel Service Co · Louisville, KYBuilt 2004 · S/N 0847 N159UPUnited Parcel Service Co · Louisville, KYBuilt 2004 · S/N 0848 N160UPUnited Parcel Service Co · Louisville, KYBuilt 2004 · S/N 0849 N161UPUnited Parcel Service Co · Louisville, KYBuilt 2004 · S/N MSN 0850 N162UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0851 N163UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0852 N164UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0853 N165UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0854 N166UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0861 N167UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0862 N168UPUnited Parcel Service Co · Louisville, KYBuilt 2005 · S/N 0863 N169UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0864 N170UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0865 N171UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0866 N172UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0867

Back to AD 2017-08-13