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.

N744SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10200 N745JBWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000071 N745SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10201 N746SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10202 N748EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10158 N748RRWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000072 N748SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10203 N750BDWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000075 N750EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10161 N750SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10207 N751ABWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000078 N751EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10163 N751SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10208 N752SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10209 N753EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10169 N753SKSkywest Airlines Inc · St George, UTBuilt 2005 · S/N 10214 N754EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10173 N754SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10215 N755SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10220 N756CMZheart Aviation LLC · Fairport, NYBuilt 2008 · S/N 5728 N756SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10221 N758CCCtb Inc · Milford, INBuilt 1997 · S/N 5353 N758EVSkywest Airlines Inc · St George, UTBuilt 2005 · S/N 10210 N759EVSkywest Airlines Inc · St George, UTBuilt 2005 · S/N 10211 N75NPOso Fleet LLC · Jacksonville Beach, FLBuilt 2011 · S/N 5873 N760EVSkywest Airlines Inc · St George, UTBuilt 2005 · S/N 10212 N760PX760px LLC · Colchester, CTBuilt 2000 · S/N 5465 N761NDSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10213 N765WTW W Tichenor & Co Inc · San Antonio, TXBuilt 1989 · S/N 5039 N767SASlate Aircraft Company LLC · Johnstown, PABuilt 2003 · S/N 7870 N7700Wilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 5745 N770WWBravo Aviation LLC · Santa Rosa Beach, FLBuilt 1995 · S/N 5177 N77195Wells Fargo Trust Co Na Trustee · Salt Lake City, UTS/N 7195 N774JGWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000007 N776MSWilmington Trust Company Trustee · Wilmington, DEBuilt 2004 · S/N 17000050 N777DBCosmos Air LLC · Las Vegas, NVBuilt 2012 · S/N 5894 N777GUGug LLC · Doral, FLBuilt 1990 · S/N 5084 N777MVAdm Prime LLC · Camden, DEBuilt 2002 · S/N 5532 N778RHWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000054 N779LGBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 5621 N779RNWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000055 N782SMWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000022 N783LCWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000018 N785BRWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000056 N786SMWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000052 N787LG5626 Company LLC · Sarasota, FLBuilt 2005 · S/N 5626 N7886Polar Bear Express II LLC · Las Vegas, NVBuilt 2003 · S/N 5559 N788CGCorning Inc · Corning, NYBuilt 2009 · S/N 8104 N788CJWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000051 N789DCRegistered aircraftBuilt 2026 · S/N 6230

Back to AD 2003-05-10 R1