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.

N789SSWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000060 N790MKWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000061 N791SASlate 791 Holdings LLC · Johnstown, PABuilt 2004 · S/N 7968 N792JBWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000064 N794JHWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000066 N794SBBcn Equipment LLC · Dallas, TXBuilt 2012 · S/N 5892 N794SCAloft Aviation Services LLC · Spartanburg, SCBuilt 1990 · S/N 5082 N798CCWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000070 N79CGC&G Destinations LLC · Fort Lauderdale, FLBuilt 2004 · S/N 5576 N7PSInnovation First Transportation Inc · Greenville, TXBuilt 1988 · S/N 5027 N800AYSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 8000 N800WCKpat LLC · Menlo Park, CABuilt 1998 · S/N 5386 N801AYSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 8001 N805AYLogos Aviation Inc · Fort Lauderdale, FLBuilt 2005 · S/N 8005 N807DDFalcon Aviation Z LLC · Great Neck, NYBuilt 1994 · S/N 5161 N80DXSsc Enterprises LLC · Camarillo, CABuilt 1998 · S/N 5365 N810DWings Of Time LLC · Carlsbad, CABuilt 1996 · S/N 5331 N810GT8ten LLC · Tulsa, OKBuilt 2004 · S/N 5600 N810MDUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 17000026 N811FLGulf & Caribbean Cargo Inc · Waterford, MIBuilt 1994 · S/N 7029 N813AYFrontera Flight Holdings Inc · Dover, DEBuilt 2005 · S/N 8013 N813JATrademark Aviation LLC · Camden, DEBuilt 1996 · S/N 5308 N813LSLove Airlines LLC · Dallas, TXBuilt 1995 · S/N 5159 N813MSCypress Cove Air LLC · Phoenix, AZBuilt 1994 · S/N 5171 N813TAAjenat Holdings LLC · Washington, DCBuilt 2011 · S/N 5869 N814PSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 5544 N815MDUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 17000034 N818ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 5799 N818AFCorbin Aviation LLC · Durant, OKBuilt 1998 · S/N 5395 N818MDUmb Bank Na Trustee · Salt Lake City, UTS/N 17000039 N819AYSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2005 · S/N 8019 N820ASBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 7188 N820AYSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2005 · S/N 8020 N821AYLogos Aviation Inc · Fort Lauderdale, FLBuilt 2005 · S/N 8021 N821FLGulf & Caribbean Cargo Inc · Waterford, MIBuilt 2005 · S/N 8058 N823AYFrontera Flight Holdings Inc · Dover, DEBuilt 2005 · S/N 8023 N823KDEast Shore Aviation LLC · Fort Lauderdale, FLBuilt 2004 · S/N 5584 N823MDUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 17000044 N824AYBeautech Power Systems LLC · Dallas, TXBuilt 2005 · S/N 8024 N824MDUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 17000045 N825AYFrontera Flight Holdings Inc · Dover, DEBuilt 2005 · S/N 8025 N825SGPlane Fetch Charter LLC · Anaheim, CABuilt 1994 · S/N 5146 N826AYSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2005 · S/N 8026 N827AYLogos Aviation Inc · Fort Lauderdale, FLBuilt 2005 · S/N 8027 N828TKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 5897 N828WGWg Aero LLC · Anchorage, AKBuilt 1991 · S/N 5080 N829AYFrontera Flight Holdings Inc · Dover, DEBuilt 2005 · S/N 8029 N82RLWkair 3 LLC · Boerne, TXBuilt 2001 · S/N 5485 N830AYGold Coast Aviation · Fort Lauderdale, FLBuilt 2005 · S/N 8030 N830CHWwbv Aviation LLC · Beachwood, OHBuilt 2013 · S/N 5954

Back to AD 2003-05-10 R1