Skip to content

Registered aircraft · 708

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-R3') 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-R3') 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-R3')
    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-R3')
  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-R3')
  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-R3')
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.

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 N850MTBank Of Utah Trustee · Salt Lake City, UTS/N 25159

Back to AD 97-09-02 R3