Registered aircraft · 417

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:2000-20-03-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:2000-20-03-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:2000-20-03-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:2000-20-03-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:2000-20-03-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:2000-20-03-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.

N633SASlate Aircraft Company LLC · Johnstown, PAS/N 7988 N650RSSchumacher Oil LLC · Whitefish, MTS/N 7779 N659BRLogos Aviation Inc · Fort Lauderdale, FLBuilt 2001 · S/N 7509 N675BRLogos Aviation Inc · Fort Lauderdale, FLBuilt 2002 · S/N 7635 N679SASkywest Airlines Inc · St George, UTS/N 7652 N685BRBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 7712 N686BRBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 7715 N693BRSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7761 N699BRSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7801 N701BRCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2000 · S/N 7448 N703SAC&S Crj200-1 LLC · Beverly, MABuilt 2003 · S/N 7730 N709BRSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7850 N70EVBank Of Utah Trustee · Salt Lake City, UTS/N 8009 N710AVBank Of Utah Trustee · Salt Lake City, UTS/N 7165 N711WSTvpx Aircraft Solutions Trustee · North Salt Lake, UTBuilt 1996 · S/N 7140 N715AVLead And Steel 3 LLC · Fountain Valley, CABuilt 1996 · S/N 7158 N715JFFabair LLC · Milwaukee, WIBuilt 2008 · S/N 8095 N7164Crj Capital Corp · Miami, FLBuilt 1997 · S/N 7164 N719AVLead And Steel LLC · Fountain Valley, CABuilt 1996 · S/N 7159 N71AVWells Fargo Trust Co Na Trustee · Salt Lake City, UTS/N 7124 N720AVWells Fargo Trust Co Na Trustee · Salt Lake City, UTS/N 7226 N749AVBank Of Utah Trustee · Salt Lake City, UTS/N 7378 N757AVBank Of Utah Trustee · Salt Lake City, UTS/N 7394 N767SASlate Aircraft Company LLC · Johnstown, PABuilt 2003 · S/N 7870 N770AVBank Of Utah Trustee · Salt Lake City, UTS/N 7130 N77195Wells Fargo Trust Co Na Trustee · Salt Lake City, UTS/N 7195 N778AVBank Of Utah Trustee · Salt Lake City, UTS/N 7784 N788CGCorning Inc · Corning, NYBuilt 2009 · S/N 8104 N791SASlate 791 Holdings LLC · Johnstown, PABuilt 2004 · S/N 7968 N800AYSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 8000 N801AYSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 8001 N805AYLogos Aviation Inc · Fort Lauderdale, FLBuilt 2005 · S/N 8005 N811FLGulf & Caribbean Cargo Inc · Waterford, MIBuilt 1994 · S/N 7029 N813AYFrontera Flight Holdings Inc · Dover, DEBuilt 2005 · S/N 8013 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 N824AYBeautech Power Systems LLC · Dallas, TXBuilt 2005 · S/N 8024 N825AYFrontera Flight Holdings Inc · Dover, DEBuilt 2005 · S/N 8025 N826AYSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2005 · S/N 8026 N827AYLogos Aviation Inc · Fort Lauderdale, FLBuilt 2005 · S/N 8027 N829AYFrontera Flight Holdings Inc · Dover, DEBuilt 2005 · S/N 8029 N830AYGold Coast Aviation · Fort Lauderdale, FLBuilt 2005 · S/N 8030 N831AYBeautech Power Systems LLC · Dallas, TXBuilt 2005 · S/N 8031 N831FLGulf & Caribbean Cargo Inc · Waterford, MIBuilt 2006 · S/N 8061 N832AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 8032 N834AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 8034

Back to AD 2000-20-03 R1