Skip to content

Registered aircraft · 269

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:2010-19-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2010-19-01') 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:2010-19-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2010-19-01')
  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:2010-19-01')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2010-19-01')
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 N11106United Airlines Inc · Chicago, ILBuilt 2002 · S/N 145650 N11107United Airlines Inc · Chicago, ILBuilt 2002 · S/N 145654 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 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 N12157United Airlines Inc · Chicago, ILBuilt 2004 · S/N 145787 N12160United Airlines Inc · Chicago, ILBuilt 2004 · S/N 145799 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 N13123Delux Public Charter LLC · Dallas, TXBuilt 2003 · S/N 145688 N13124United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145689 N13132United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145708 N13133United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145712 N13161United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500805 N135SGValiair Lc Trustee · Casper, WYBuilt 2003 · S/N 145706 N13979Delux Public Charter LLC · Dallas, TXBuilt 1999 · S/N 145181 N13992Delux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145284 N14105Delux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145649 N14116United Airlines Inc · Chicago, ILBuilt 2002 · S/N 145672 N14125United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145690 N14143United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145739 N14148United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145751 N14153United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145761 N14158United Airlines Inc · Chicago, ILBuilt 2004 · S/N 145791 N14162United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500808 N14168United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500840 N14173United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500872

Back to AD 2010-19-01