Skip to content

Registered aircraft · 709

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

N760USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1354 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 N762USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1358 N763USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1360 N764USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1369 N765SWSouthwest Airlines Co · Dallas, TXBuilt 2000 · S/N 29805 N765USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1371 N766USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1378 N767UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1382 N768USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1389 N769USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1391 N770UWUmb Bank N A Trustee · Salt Lake City, UTBuilt 2000 · S/N 1393 N7713ASouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 33919 N7715ESouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 33921 N771XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2003 · S/N 1980 N7721ESouthwest Airlines Co · Dallas, TXBuilt 2006 · S/N 34479 N7723ESouthwest Airlines Co · Dallas, TXBuilt 2006 · S/N 32670 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 N772XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2003 · S/N 1997 N773XFWilmington Trust Co Trustee · Wilmington, DEBuilt 2003 · S/N 2012 N7777QCobra Aviation Services LLC · Oklahoma City, OKBuilt 2002 · S/N 33036 N778SWSouthwest Airlines Co · Dallas, TXBuilt 2000 · S/N 27883 N7824AUnical Aviation Inc · Glendale, AZBuilt 2001 · S/N 30617 N78285Umb Bank N A Trustee · Salt Lake City, UTBuilt 2004 · S/N 33452 N782SPLiberty University Inc · Lynchburg, VABuilt 1968 · S/N 46013 N783SWSouthwest Airlines Co · Dallas, TXBuilt 2000 · S/N 29809 N7865AUnical Aviation Inc · Glendale, AZBuilt 2002 · S/N 30647 N789LSGryphon Trading 18 LLC · Fort Lauderdale, FLBuilt 1988 · S/N 24269 N79279United Airlines Inc · Chicago, ILBuilt 2003 · S/N 31597 N79402United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30119 N800KSAej Services LLC · Los Angeles, CABuilt 2000 · S/N 30782 N801SYSun Country Inc · Minneapolis, MNBuilt 2001 · S/N 30332 N802DHHeavylift Cargo Airlines Inc · Kingman, AZS/N 46076 N803DHHeavylift Cargo Airlines Inc · Kingman, AZS/N 46123 N804DHBjw Services Inc · Kingman, AZS/N 46091 N804SYSun Country Inc · Minneapolis, MNBuilt 2001 · S/N 30689 N804TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1989 · S/N 23988 N805SYSun Country Inc · Minneapolis, MNBuilt 2001 · S/N 30032 N806TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1992 · S/N 27081 N807TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1992 · S/N 25098 N808TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1993 · S/N 25103 N809SYSun Country Inc · Minneapolis, MNBuilt 2005 · S/N 30683 N811TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1986 · S/N 23538 N836BABoeing Co · Gary, INBuilt 2000 · S/N 30756

Back to AD 97-09-02 R2