Skip to content

AD 2000-20-03 R1

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.

N8946ABank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 7946 N8948BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 7948 N8960AAm Pm Services LLC - Adventure Series · Northbrook, ILBuilt 2004 · S/N 7960 N8964EAm Pm Services LLC - Adventure Series · Northbrook, ILBuilt 2004 · S/N 7964 N8969AGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7969 N8970DGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7970 N8971AAm Pm Services LLC - Adventure Series · Northbrook, ILBuilt 2004 · S/N 7971 N8974CSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 7974 N8976ESlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 7976 N8980AViajet LLC · Johnstown, PABuilt 2004 · S/N 7980 N8982AGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7982 N8986BSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 7986 N900EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7608 N901EVSkywest Airlines Inc · Saint George, UTBuilt 2002 · S/N 7616 N902EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7620 N903EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7621 N904EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7628 N905EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7632 N906EVSkywest Airlines Inc · St George, UTS/N 7642 N907EVSkywest Airlines Inc · St George, UTS/N 7648 N907SALead And Steel 2 LLC · Fountain Valley, CABuilt 2004 · S/N 7934 N908EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7654 N908SWSkywest Airlines Inc · St George, UTBuilt 2001 · S/N 7540 N909EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7658 N909SWSkywest Airlines Inc · Saint George, UTBuilt 2001 · S/N 7558 N910EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7727 N910SWSkywest Airlines Inc · St George, UTBuilt 2001 · S/N 7566 N912EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7728 N912SWSkywest Airlines Inc · St George, UTBuilt 2001 · S/N 7595 N913EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7731 N914EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7752 N915EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7754 N915SWSkywest Airlines Inc · St George, UTS/N 7615 N916EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7757 N916SWSkywest Ailines Inc · St George, UTBuilt 2002 · S/N 7634 N917EVSkywest Airlines Inc · Saint George, UTBuilt 2003 · S/N 7769 N917SWSkywest Airlines Inc · Saint George, UTS/N 7641 N918SWSkywest Airlines Inc · St George, UTS/N 7645 N919EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7780 N919SWCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2002 · S/N 7657 N920EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7810 N920SWCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2002 · S/N 7660 N921EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7819 N922EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7822 N923EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7826 N923SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7664 N924CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 7494 N924SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7681 N925EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7831 N925SWCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2002 · S/N 7682

Back to AD 2000-20-03 R1