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.

N501KVRoman Empire Aba Services Inc · Goodyear, AZBuilt 1995 · S/N 5173 N502AEAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 10018 N502GJBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 10011 N503GJBank Of Utah Trustee · Salt Lake City, UTS/N 10019 N505AEAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 10053 N506AEAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 10056 N506CASkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7793 N506RTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 6093 N507AEAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 10059 N508AEAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 10072 N509AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10078 N509GJSkywest Leasing Inc · St George, UTBuilt 2004 · S/N 10153 N50AGGh Consulting Services LLC · Scottsdale, AZBuilt 2011 · S/N 5891 N510AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10105 N510SJN510sj LLC · Las Vegas, NVBuilt 2001 · S/N 7481 N511AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10107 N511DDDesert Aviation Partners LLC · Anchorage, AKBuilt 1995 · S/N 5187 N513AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10114 N514AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10119 N514JYLabutte LLC · Dearborn, MIBuilt 2017 · S/N 6110 N515AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10121 N515LFAdelante Aviation LLC · Leawood, KSBuilt 1986 · S/N 3052 N515LT1588 Aviation LLC · Houston, TXBuilt 2000 · S/N 5467 N516AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10123 N517AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10124 N517BBShiloh International Inc · Brooklyn, NYS/N 5047 N518AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10126 N518JABfja LLC · Glenbrook, NVBuilt 2007 · S/N 5719 N518JGJoe Gibbs Racing LLC · Huntersville, NCBuilt 2002 · S/N 5545 N519AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10131 N519GJBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 10026 N520DCAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10140 N520GJBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 10065 N521AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10142 N522AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10147 N523AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10152 N523ARBongo Bird LLC · Birmingham, ALBuilt 2010 · S/N 5839 N523GJSkywest Leasing Inc · St George, UTBuilt 2003 · S/N 10125 N523JGRama Z2 LLC · Bellevue, WABuilt 2001 · S/N 5508 N524AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10154 N525SDSkye Gryphon LLC · Londonderry, NHBuilt 2009 · S/N 5790 N526GJSkywest Leasing Inc · Saint George, UTBuilt 2004 · S/N 10129 N527GJUnited Airlines Inc · Chicago, ILS/N 10004 N527JAFg&N Plane Partners LLC · Kalamazoo, MIBuilt 1989 · S/N 5058 N528GJUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 10031 N528MCBorealis Partners LLC · Dallas, TXBuilt 1996 · S/N 5328 N530BDSerenity Consultants LLC · Scottsdale, AZBuilt 1997 · S/N 5352 N530GJSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10216 N530JWBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 8109 N532GJSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10219

Back to AD 2003-05-10 R1