Skip to content

Registered aircraft · 816

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

N732CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1989 · S/N 24271 N733CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1992 · S/N 25849 N734CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1993 · S/N 25858 N7352CCsds Asset Management LLC · Rllng Hls Est, CAS/N 26340 N7353CCsds Asset Management LLC · Rllng Hls Est, CAS/N 27634 N7354CCsds Asset Management LLC · Rllng Hls Est, CAS/N 27425 N735EDynamic Aviation Group Inc · Bridgewater, VAS/N 26339 N735TDynamic Avlease Inc · Bridgewater, VABuilt 1990 · S/N 24651 N746AAMidnight Engineering LLC · Fort Lauderdale, FLS/N 26639 N76254United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30779 N76265United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31585 N76269United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31588 N76288United Airlines Inc · Chicago, ILBuilt 2004 · S/N 33451 N76502United Airlines Inc · Chicago, ILBuilt 2006 · S/N 31603 N76503United Airlines Inc · Chicago, ILBuilt 2006 · S/N 33461 N76504United Airlines Inc · Chicago, ILBuilt 2006 · S/N 31604 N76505United Airlines Inc · Chicago, ILBuilt 2006 · S/N 32834 N76508United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31639 N76514United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31626 N76515United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31623 N76516United Airlines Inc · Chicago, ILBuilt 2008 · S/N 37096 N76517United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31628 N76519United Airlines Inc · Chicago, ILBuilt 2010 · S/N 30132 N76522United Airlines Inc · Chicago, ILBuilt 2010 · S/N 31660 N76523United Airlines Inc · Chicago, ILBuilt 2010 · S/N 37101 N76526United Airlines Inc · Chicago, ILBuilt 2010 · S/N 38700 N76528United Airlines Inc · Chicago, ILBuilt 2010 · S/N 31663 N76529United Airlines Inc · Chicago, ILBuilt 2010 · S/N 31652 N76532United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62749 N76533United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62748 N77258United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30802 N77261United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31582 N77295United Airlines Inc · Chicago, ILBuilt 2005 · S/N 34001 N77296United Airlines Inc · Chicago, ILBuilt 2005 · S/N 34002 N77510United Airlines Inc · Chicago, ILBuilt 2008 · S/N 32828 N77518United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31605 N77520United Airlines Inc · Chicago, ILBuilt 2010 · S/N 31658 N77525United Airlines Inc · Chicago, ILBuilt 2010 · S/N 31659 N77530United Airlines Inc · Chicago, ILBuilt 2011 · S/N 39998 N77535United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62751 N77536United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62766 N77537United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62767 N77538United Airlines Inc · Chicago, ILBuilt 2016 · S/N 63694 N77539United Airlines Inc · Chicago, ILBuilt 2017 · S/N 63642 N77542United Airlines Inc · Chicago, ILBuilt 2017 · S/N 63647 N778MAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 34704 N78285Umb Bank N A Trustee · Salt Lake City, UTBuilt 2004 · S/N 33452 N7835ASouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 34294 N7843ABank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 35786 N7844ABank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35118

Back to AD 99-26-21