Skip to content

Registered aircraft · 326

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

N111REX Aviation Group LLC · Beverly Hills, CABuilt 1988 · S/N 49670 N112PSFrontera Flight Holdings Inc · Dover, DEBuilt 1967 · S/N 47013 N120UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 29166 N120UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 0805 N121UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 0806 N122UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 29168 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 N127NKPerris Valley Airport Inc · Perris, CAS/N 47361 N127UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 0811 N128UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0812 N129TWLogistic Air Inc · Reno, NVBuilt 1976 · S/N 21141 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 N141WEOmega Air Inc · San Antonio, TXS/N 46661 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 N158JPAerotrust Services Corp Trustee · Wilmington, DES/N 53195 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

Back to AD 89-06-03