Skip to content

AD 2003-05-10 R1

Registered aircraft · 1,108

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-05-10-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-05-10-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-05-10-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-05-10-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-05-10-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-05-10-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.

N924CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 7494 N924FJBank Of Utah Trustee · Salr Lake City, UTBuilt 2004 · S/N 15024 N924SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7681 N925EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7831 N925FJBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 15025 N925SWCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2002 · S/N 7682 N926ECJcpe LLC · Boston, MABuilt 2010 · S/N 5832 N926EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7843 N926LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 15026 N926SSJcpe LLC · Boston, MABuilt 1999 · S/N 5436 N926SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7687 N927EVFrontera Flight Holdings Inc · Dover, DEBuilt 2003 · S/N 7844 N927LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15027 N927SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7693 N928EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 8006 N928LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15028 N928SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7701 N929EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 8007 N929LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15029 N929SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7703 N930LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15030 N930SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7713 N931EVSkywest Airlines Inc · St George, UTBuilt 2005 · S/N 8015 N931LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15031 N932EVSkywest Airlines Inc · St George, UTBuilt 2005 · S/N 8016 N932LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15032 N932SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7714 N933EVSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 8022 N933LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15033 N934SWSkywest Airlines Inc · Saint George, UTBuilt 2002 · S/N 7722 N935LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15035 N935SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7725 N936EVSkywest Airlines Inc · St George, UTBuilt 2005 · S/N 8038 N936SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7726 N937EVSkywest Airlines Inc · St George, UTBuilt 2005 · S/N 8042 N937SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7735 N938SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7741 N939SWSkywest Airlines Inc · Saint George, UTBuilt 2003 · S/N 7742 N93EAElite Airways LLC · Portland, MEBuilt 2001 · S/N 7563 N94Federal Aviation Administration · Oklahoma City, OKBuilt 2010 · S/N 5855 N941SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7750 N943SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7762 N944SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7764 N945FSFly Fishin C LLC · Austin, TXBuilt 1998 · S/N 5370 N945SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7770 N946SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7776 N947SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7786 N949MCWolfpack Aviation LLC · Tysons, VABuilt 2010 · S/N 5829 N949SJSierra Delta Romeo LLC · Scottsdale, AZBuilt 1996 · S/N 7136 N94SFTriad Aviation LLC · Tyler, TXBuilt 2007 · S/N 5708

Back to AD 2003-05-10 R1