Skip to content

Registered aircraft · 106

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-17-04-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:97-17-04-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:97-17-04-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:97-17-04-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:97-17-04-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:97-17-04-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.

N833USUSA Jet Airlines Inc · Belleville, MIBuilt 1991 · S/N 53215 N834USUSA Jet Airlines Inc · Belleville, MIBuilt 1990 · S/N 53115 N835USUSA Jet Airlines Inc · Belleville, MIBuilt 1990 · S/N 53172 N836USUSA Jet Airlines Inc · Belleville, MIBuilt 1991 · S/N 53214 N837USUSA Jet Airlines Inc · Belleville, MIBuilt 1991 · S/N 53257 N83GFWilmington Trust Co Trustee · Wilmington, DEBuilt 1991 · S/N 49950 N842USUSA Jet Airlines Inc · Belleville, MIBuilt 1992 · S/N 53380 N861GAWorld Atlantic Leasing LLC · Miami Springs, FLBuilt 1987 · S/N 49557 N883GAFalcon Commercial Aviation LLC · Miami, FLBuilt 1988 · S/N 49710 N887GARising Sun Aviation LLC · Irving, TXBuilt 1990 · S/N 49932 N908JEJet Assets Inc · Cheyenne, WYS/N 20115 N909PGArgenjet Air Lease Inc · Miami, FLNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 21852 N913DECorsair Two LLC · Hillsboro, ORBuilt 1993 · S/N 49956 N918AVBank Of Utah Trustee · Salt Lake City, UTBuilt 1982 · S/N 49104 N9409FFronteraflight Holdings Inc · Dover, DEBuilt 1992 · S/N 53121 N950NSCorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53023 N9615WJetran LLC · Horseshoe Bay, TXBuilt 1997 · S/N 53562 N9616GJetran LLC · Horseshoe Bay, TXBuilt 1997 · S/N 53563 N9617RJetran LLC · Horseshoe Bay, TXBuilt 1997 · S/N 53564 N9618AJetran LLC · Horseshoe Bay, TXBuilt 1997 · S/N 53565 N9619VJetran LLC · Horseshoe Bay, TXBuilt 1997 · S/N 53566 N961CEArctic One LLC · Fairbanks, AKBuilt 1987 · S/N 49470 N961TWJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 53611 N9620DJetran LLC · Horseshoe Bay, TXBuilt 1997 · S/N 53591 N9622AJetran LLC · Horseshoe Bay, TXBuilt 1998 · S/N 53593 N9624TJetran LLC · Horseshoe Bay, TXBuilt 1998 · S/N 53594 N9625WJetran LLC · Horseshoe Bay, TXBuilt 1998 · S/N 53595 N9626FJetran LLC · Horseshoe Bay, TXBuilt 1998 · S/N 53596 N9628WJetran LLC · Horseshoe Bay, TXBuilt 1998 · S/N 53598 N962CEArctic One LLC · Fairbanks, AKBuilt 1996 · S/N 53471 N962TWJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 53612 N9630AJetran LLC · Horseshoe Bay, TXBuilt 1997 · S/N 53561 N963CEArctic One LLC · Fairbanks, AKBuilt 1994 · S/N 53450 N963TWJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 53613 N964CEArctic One LLC · Fairbanks, AKBuilt 1992 · S/N 53078 N964TWJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 53614 N965CEArctic One LLC · Fairbanks, AKBuilt 1992 · S/N 53079 N965TWJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 53615 N966CEArctic One LLC · Fairbanks, AKBuilt 1991 · S/N 53266 N967CEArctic One LLC · Fairbanks, AKBuilt 1996 · S/N 49855 N967TWJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 53617 N968TWJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 53618 N969TWJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 53619 N970TWJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 53620 N972TWJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 53622 N976TWBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 53626 N979TWJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 53629 N980TWJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 53630 N982CABank Of Utah Trustee · Salt Lake City, UTBuilt 1986 · S/N 49415 N982TWJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 53632

Back to AD 97-17-04 R1