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.

N831AYBeautech Power Systems LLC · Dallas, TXBuilt 2005 · S/N 8031 N831FLGulf & Caribbean Cargo Inc · Waterford, MIBuilt 2006 · S/N 8061 N831PBRaynemen LLC · Pebble Beach, CABuilt 2012 · S/N 5895 N832AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 8032 N832SCNwt Aircraft Co · Lexington, KYBuilt 2023 · S/N 6189 N834AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 8034 N835AYFrontera Flight Holdings Inc · Dover, DEBuilt 2005 · S/N 8035 N836AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 8036 N8390ADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 7390 N83UFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1990 · S/N 5083 N8409NDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 7409 N840AYSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2005 · S/N 8040 N8416BDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 7416 N841FLGulf & Caribbean Cargo Inc · Waterford, MIBuilt 2006 · S/N 8064 N841NPeninsula Air Logistics LLC · Palo Alto, CABuilt 2016 · S/N 6086 N841SDBluemont Leaf LLC · Houston, TXBuilt 2006 · S/N 5646 N843CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 5660 N843GSReserve Aircrafts LLC · New York, NYBuilt 1995 · S/N 5184 N8458ALogos Aviation Inc · Fort Lauderdale, FLBuilt 2000 · S/N 7458 N845ASDodson International Parts Inc · Rantoul, KSBuilt 1999 · S/N 7324 N845SASlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 7965 N847CCJcpe LLC · Boston, MABuilt 2017 · S/N 6091 N8492CDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 7492 N8495BDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 7495 N8501FDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 7501 N8505QAm Pm Services LLC - Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7505 N8506CAm Pm Services LLC - Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7506 N850NBValiair Lc Trustee · Casper, WYBuilt 1997 · S/N 7211 N850RDLgs Holding Group 2013 LLC · Stockbridge, GABuilt 2009 · S/N 8103 N850RJUS Department Of Energy · Richland, WABuilt 1996 · S/N 7152 N8515FAm Pm Services LLC - Series One · Northbrook, ILBuilt 2001 · S/N 7515 N8516CAm Pm Services LLC- Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7516 N851GKKkh Rentals Inc · San Antonio, TXBuilt 2006 · S/N 5643 N8525BAm Pm Services LLC - Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7525 N8532GAm Pm Services LLC- Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7532 N8533DAm Pm Services Llcblue Sky Series · Northbrook, ILBuilt 2001 · S/N 7533 N8541DAm Pm Services LLC - Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7541 N854ASSkywest Airlines Inc · St. George, UTBuilt 2000 · S/N 7382 N8554AAm Pm Services LLC - Blue Sky Series · Northbrook, ILBuilt 2001 · S/N 7554 N855MMMarklyn Jet Parts LLC · Dallas, TXBuilt 1990 · S/N 5064 N855RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000077 N8560FAm Pm Services LLC - Blue Skies Series · Northbrook, ILBuilt 2001 · S/N 7560 N856ASSkywest Airlines Inc · St George, UTBuilt 2000 · S/N 7404 N856PPWkair4 LLC · Boerne, TXBuilt 2001 · S/N 5483 N8577DAm Pm Services LLC · Northbrook, ILBuilt 2001 · S/N 7577 N857RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000079 N8580AAm Pm Services LLC - Alpha Series · Northbrook, ILBuilt 2001 · S/N 7580 N8587EAm Pm Services LLC - Alpha Series · Northbrook, ILBuilt 2001 · S/N 7587 N8588DAm Pm Services LLC - Alpha Serie · Northbrook, ILBuilt 2001 · S/N 7588 N858CV28039 LLC · North Olmsted, OHBuilt 2008 · S/N 5772

Back to AD 2003-05-10 R1