Skip to content

AD 2000-22-02 R1

Registered aircraft · 823

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-22-02-R1') 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-22-02-R1') 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-22-02-R1')
    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-22-02-R1')
  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-22-02-R1')
  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-22-02-R1')
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.

N444HECsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1987 · S/N 23800 N465TWSierra American Corp · Wilmington, DES/N 23465 N467TWSierra American Corp · Wilmington, DES/N 23466 N471DSBoeing Co · Renton, WABuilt 2025 · S/N 68737 N475USUS Department Of Homeland Security · Arlington, VABuilt 2004 · S/N 33789 N477USUS Department Of Homeland Security · Arlington, VABuilt 2003 · S/N 33785 N506ASUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 35690 N508ASAlaska Airlines Inc · Seattle, WABuilt 2008 · S/N 35691 N512ASWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 39043 N513ASUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 35192 N514ASAlaska Airlines Inc · Seattle, WABuilt 2008 · S/N 35193 N516ASWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 39044 N517ASAlaska Airlines Inc · Seatac, WABuilt 2008 · S/N 35197 N518ASAlaska Airlines Inc · Seattle, WABuilt 2009 · S/N 35693 N519ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 36482 N520ASAlaska Airlines Inc · Seattle, WABuilt 2009 · S/N 36481 N523ASWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 35194 N524ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 35195 N525ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 35692 N526ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 35196 N527ASAlaska Airlines Inc · Seatac, WAS/N 35694 N528ASAlaska Airlines Inc · Seattle, WABuilt 2009 · S/N 35695 N529ASAlaska Airlines Inc · Seatac, WABuilt 2010 · S/N 35198 N530ASAlaska Airlines Inc · Seattle, WABuilt 2010 · S/N 36578 N531ASAlaska Airlines Inc · Seattle, WABuilt 2010 · S/N 35199 N532ASAlaska Airlines Inc · Seatac, WABuilt 2010 · S/N 36346 N533ASAlaska Airlines Inc · Seatac, WABuilt 2011 · S/N 35201 N534ASAlaska Airlines Inc · Seatac, WABuilt 2011 · S/N 35202 N535ASAlaska Airlines Inc · Seattle, WABuilt 2011 · S/N 35200 N536ASAlaska Airlines Inc · Seattle, WABuilt 2012 · S/N 35203 N537ASAlaska Airlines Inc · Seatac, WABuilt 2012 · S/N 35204 N538ASAlaska Airlines Inc · Seattle, WABuilt 2012 · S/N 41188 N54241United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28953 N546ASAlaska Airlines Inc · Seattle, WABuilt 2005 · S/N 30022 N54711United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28782 N548ASAlaska Airlines Inc · Seattle, WABuilt 2005 · S/N 30020 N551ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 34593 N552ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 34595 N553ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 34594 N554WTAerownership North American Services Inc Trustee · Dover, DES/N 28554 N556ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35175 N557ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35176 N558ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35177 N559ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35178 N560ASAlaska Airlines Inc · Seatac, WABuilt 2006 · S/N 35179 N562ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 35091 N563ASAlaska Airlines Inc · Seatac, WABuilt 2006 · S/N 35180 N563WNWilmington Trust Co Trustee · Wilmington, DEBuilt 2002 · S/N 34296 N564ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 35103 N565ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35181

Back to AD 2000-22-02 R1