Skip to content

AD 2000-03-03 R1

Registered aircraft · 781

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-03-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-03-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-03-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-03-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-03-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-03-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.

N8800GTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 7800 N8808HTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 7808 N880ASSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7606 N880FCFawkescorp LLC · Lewes, DES/N 5337 N881ASSkywest Airlines Inc · Saint George, UTBuilt 2001 · S/N 7496 N8828DBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 7828 N882SFSuperior Aviation Inc Trustee · Orlando, FLS/N 7460 N8836AGold Coast Aviation · Fort Lauderdale, FLBuilt 2003 · S/N 7836 N8847ASlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2003 · S/N 7847 N8855ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 7855 N8869BViajet LLC · Johnstown, PABuilt 2003 · S/N 7869 N886ASSkywest Airlines Inc · St George, UTBuilt 2001 · S/N 7531 N8877ASlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2003 · S/N 7877 N8886AGold Coast Aviation · Fort Lauderdale, FLBuilt 2003 · S/N 7886 N888DHCanadair 5305 LLC · Dover, DEBuilt 1996 · S/N 5305 N888QLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 5566 N8891AGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7891 N8896AGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7896 N889ASFrontera Flight Holdings Inc · Dover, DEBuilt 2001 · S/N 7538 N8908DSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 7908 N890SARi Millennium I LLC · Beverly, MABuilt 2001 · S/N 7548 N8921BAm Pm Services LLC · Northbrook, ILBuilt 2004 · S/N 7921 N8930EBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 7930 N8933BGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7933 N8936AGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7936 N8940EAm Pm Services LLC - Adventure Series · Northbrook, ILBuilt 2004 · S/N 7940 N8942AViajet LLC · Johnstown, PABuilt 2004 · S/N 7942 N8943AGold Coast Aviation · Fort Lauderdale, FLBuilt 2004 · S/N 7943 N8944BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 7944 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 N898AKPoppa Air II LLC · Wellesley, MABuilt 2001 · S/N 5490 N900EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7608 N901EVSkywest Airlines Inc · Saint George, UTBuilt 2002 · S/N 7616 N902AGT C Management Of Florida Inc · Naples, FLBuilt 2001 · S/N 5512 N902BResurrection House For All Nations Inc · Union City, GABuilt 1987 · S/N 5005 N902EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7620 N902FJSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 15002 N903EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7621 N904EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7628

Back to AD 2000-03-03 R1