Skip to content

Registered aircraft · 571

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

N100MAMartin Equipment Inc · Englewood, COBuilt 1999 · S/N 750-0087 N10156United Airlines Inc · Chicago, ILBuilt 2004 · S/N 145786 N101VWQuantum Aviation LLC · Fort Worth, TXBuilt 1996 · S/N 750-0001 N1023CAero Aircraft Holdings II LLC · Van Nuys, CABuilt 2001 · S/N 145550 N102VRCitation X Leasing LLC · Liberty, NCBuilt 1999 · S/N 750-0102 N104RAir Play LLC · Wilmington, DEBuilt 1999 · S/N 750-0095 N106PCRyan Air LLC · Kalispell, MTBuilt 1998 · S/N 750-0061 N107AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 750-0107 N10AMRancho Pacific Holdings LLC · Rancho Cucamonga, CABuilt 2002 · S/N 750-0202 N10XTCx N10xt LLC · Addison, TXBuilt 2004 · S/N 750-0230 N110CXWh Air LLC · Clearwater, FLBuilt 1999 · S/N 750-0077 N11106United Airlines Inc · Chicago, ILBuilt 2002 · S/N 145650 N11107United Airlines Inc · Chicago, ILBuilt 2002 · S/N 145654 N11113United Airlines Inc · Chicago, ILBuilt 2002 · S/N 145662 N11119United Airlines Inc · Chicago, ILBuilt 2002 · S/N 145677 N11121United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145683 N11127United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145697 N11140United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145732 N11150United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145756 N11164United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500817 N11165United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500819 N11176United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500881 N11181United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500904 N11184United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500917 N11187United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500927 N11189United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500931 N11191United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500935 N11192United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500936 N11193United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500938 N11194United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500940 N11526Corporate Flight Managment Inc · Smyrna, TNBuilt 2001 · S/N 145410 N11535Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145518 N11536Bank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 145520 N11539Delux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145536 N11565Corporate Flight Management Inc · Smyrna, TNBuilt 2002 · S/N 145621 N119RMBald 3 LLC · Fort Worth, TXBuilt 1998 · S/N 750-0051 N12122Untied Airlines Inc · Chicago, ILBuilt 2003 · S/N 145684 N12126Avtran LLC · Clayton, MOBuilt 2003 · S/N 145693 N12135United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145718 N12136United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145719 N12142United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145735 N12145United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145745 N12157United Airlines Inc · Chicago, ILBuilt 2004 · S/N 145787 N12160United Airlines Inc · Chicago, ILBuilt 2004 · S/N 145799 N12163United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500811 N12166Delux Public Charter LLC · Dallas, TXBuilt 2004 · S/N 14500831 N12167United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500834 N12172United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500864 N12175United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500878 N12195United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500943

Back to AD 2000-18-06