Skip to content

Registered aircraft · 50

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

N438AAFrontera Flight Holding Inc · Dover, DEBuilt 1987 · S/N 49456 N566AAFrontera Flight Holding Inc · Dover, DEBuilt 1987 · S/N 49348 N572AA727x Aerospace Corp · Lewes, DES/N 49458 N590AAFrontera Flight Holdings Inc · Dover, DEBuilt 1991 · S/N 53253 N595AAPac Blue Aerospace · Fairbanks, AKBuilt 1992 · S/N 53285 N637SHPacific Aircorp 49741 Inc · San Francisco, CAS/N 49568 N801WACaribbean Sun Airlines Inc DBA · Miami, FLBuilt 1992 · S/N 53291 N806WA53251 LLC · Miami Springs, FLBuilt 1991 · S/N 53251 N807WAFederal Dynamics Corp · Henderson, NVBuilt 1993 · S/N 53093 N808WACaribbean Sun Airlines Inc · Miami, FLBuilt 1990 · S/N 53044 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 N9405TFrontera Flight Holdings Inc · Dover, DES/N 53141 N9409FFronteraflight Holdings Inc · Dover, DEBuilt 1992 · S/N 53121 N948TWKc Aviation Stem Inc · Kansas City, MOS/N 49575 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 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 N9629HJetran LLC · Horseshoe Bay, TXBuilt 1998 · S/N 53599 N962TWJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 53612 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 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 N978TWJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 53628 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 N983TWJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 53633

Back to AD 2016-07-08