Skip to content

AD 2003-03-15 R1

Registered aircraft · 368

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:2003-03-15-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:2003-03-15-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:2003-03-15-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:2003-03-15-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:2003-03-15-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:2003-03-15-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.

N883GAFalcon Commercial Aviation LLC · Miami, FLBuilt 1988 · S/N 49710 N887GARising Sun Aviation LLC · Irving, TXBuilt 1990 · S/N 49932 N904CETatonduk Outfitters Limited · Fairbanks, AKBuilt 1967 · S/N 47040 N905NANational Aeronautics And Space Administration · Houston, TXBuilt 1970 · S/N 20107 N9113DHeikkila Glenn R · Rockland, MAS/N 47577 N913DECorsair Two LLC · Hillsboro, ORBuilt 1993 · S/N 49956 N917KWAlta Airlines Holdings LLC · Salt Lake City, UTS/N 46917 N918AVBank Of Utah Trustee · Salt Lake City, UTBuilt 1982 · S/N 49104 N9218Omega Air Inc · Selma, TXS/N 48218 N923TRCareer Aviation Co Inc · Wilmington, DES/N 28923 N928KWAlta Airlines Holdings LLC · Salt Lake City, UTS/N 47928 N929DNDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 53459 N930CETatonduk Outfitters Ltd · Fairbanks, AKBuilt 1969 · S/N 47363 N930DNDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 53458 N930TBBoeing Co · Renton, WABuilt 1995 · S/N 53388 N931TBBoeing Company · Renton, WABuilt 1998 · S/N 53532 N932CETatonduk Outfitters Ltd · Fairbanks, AKBuilt 1970 · S/N 47465 N934NANational Aeronautics And Space Administration · Houston, TXS/N 47428 N935CETatonduk Outfitters Ltd · Fairbanks, AKBuilt 1969 · S/N 47413 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 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 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 N963DNBoeing Company · Renton, WABuilt 1999 · S/N 53533 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

Back to AD 2003-03-15 R1