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.

N715SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10179 N7164Crj Capital Corp · Miami, FLBuilt 1997 · S/N 7164 N716BBPinnacle Aviation Group LLC · Wilmington, DES/N 5477 N716EVSkywest Airlines Inc · Saint George, UTBuilt 2003 · S/N 10084 N716JRHugo Enterprises LLC · Omaha, NEBuilt 2010 · S/N 5847 N716PSUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 10171 N716SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10180 N716TMTitan Strong LLC · Staten Island, NYBuilt 1997 · S/N 5344 N717BNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5960 N717EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 10088 N718EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 10095 N718PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10175 N718SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10184 N719AVLead And Steel LLC · Fountain Valley, CABuilt 1996 · S/N 7159 N719EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 10099 N719PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10177 N719SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10188 N71KRLost Highway Touring Inc · Clarkston, MIBuilt 1995 · S/N 5191 N720EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 10115 N720PSUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 10178 N721GChallenger Hc LLC · New York, NYBuilt 1992 · S/N 5109 N722EVSkywest Airlines Inc · Saint George, UTBuilt 2003 · S/N 10127 N723EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10132 N723PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10181 N724EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10138 N724SKSkywest Airlines Inc · Saint George, UTBuilt 2004 · S/N 10189 N725PSAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 10186 N726RFV-Fee Challenger 604 Aviation LLC · Whippany, NJBuilt 2000 · S/N 5451 N726SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10190 N727SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10191 N728HAHamilton Aviation Inc · Portland, ORBuilt 2025 · S/N 6229 N728SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10192 N729HZChai Trust Co LLC Trustee · Chicago, ILBuilt 2008 · S/N 5749 N730BZRegistered aircraftBuilt 2002 · S/N 5531 N730EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10141 N730SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10193 N731AWCalisports Holdings LLC · San Diego, CABuilt 2008 · S/N 5761 N732PABuchalter Ventures Qof-A LLC · Montgomery, ALBuilt 2012 · S/N 5916 N732SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10194 N736EEAiles Dargent I LLC · Staten Island, NYBuilt 1999 · S/N 5428 N736MGMilam Aviation LLC · Temple, TXBuilt 2012 · S/N 5902 N738EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10146 N739AEWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000080 N740EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10151 N740MRWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000082 N740SKSkywest Airlines Inc · St George, UTBuilt 2005 · S/N 10196 N741EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10155 N742SKSkywest Airlines Inc · St George, UTBuilt 2005 · S/N 10197 N743SKSkywest Airlines Inc · St George, UTBuilt 2005 · S/N 10199 N744EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10157

Back to AD 2003-05-10 R1