Skip to content

Pan Am Railways Inc

Earlier aircraft under this name · 25

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL

SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'PAN AM RAILWAYS INC' OR list_contains(d.other_registrant_names, 'PAN AM RAILWAYS INC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_name = 'PAN AM RAILWAYS INC' OR list_contains(d.other_registrant_names, 'PAN AM RAILWAYS INC')
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
WHERE d.registrant_name = 'PAN AM RAILWAYS INC' OR list_contains(d.other_registrant_names, 'PAN AM RAILWAYS INC')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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.

N531PABritish Aerospace BAE JETSTREAM 3101 · S/N 748Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1987 · Nashua, NH N530PABritish Aerospace BAE JETSTREAM 3101 · S/N 732Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Nashua, NH N343PABoeing 727-222 · S/N 21894Cancelled Sep 15, 2009 · Triennial form not returned · Built 1979 · Portsmouth, NH N357PABoeing 727-222 · S/N 21896Cancelled Sep 15, 2009 · Triennial form not returned · Built 1979 · Portsmouth, NH N361PABoeing 727-225 · S/N 20623Cancelled Sep 15, 2009 · Triennial form not returned · Built 1973 · Portsmouth, NH N509PABritish Aerospace BAE JETSTREAM 3101 · S/N 675Cancelled Sep 15, 2009 · Triennial form not returned · Portsmouth, NH N510PABritish Aerospace BAE JETSTREAM 3101 · S/N 677Cancelled Sep 15, 2009 · Triennial form not returned · Portsmouth, NH N512PABritish Aerospace BAE JETSTREAM 3101 · S/N 678Cancelled Sep 15, 2009 · Triennial form not returned · Portsmouth, NH N514PABritish Aerospace BAE JETSTREAM 3101 · S/N 682Cancelled Sep 15, 2009 · Triennial form not returned · Portsmouth, NH N515PABritish Aerospace BAE JETSTREAM 3101 · S/N 652Cancelled Sep 15, 2009 · Triennial form not returned · Portsmouth, NH N517PABritish Aerospace BAE JETSTREAM 3101 · S/N 654Cancelled Sep 15, 2009 · Triennial form not returned · Built 1985 · Portsmouth, NH N518PABritish Aerospace BAE JETSTREAM 3101 · S/N 658Cancelled Sep 15, 2009 · Triennial form not returned · Portsmouth, NH N521PABritish Aerospace BAE JETSTREAM 3101 · S/N 702Cancelled Sep 15, 2009 · Triennial form not returned · Portsmouth, NH N528PABritish Aerospace BAE JETSTREAM 3101 · S/N 670Cancelled Sep 15, 2009 · Triennial form not returned · Portsmouth, NH N535PABritish Aerospace BAE JETSTREAM 3101 · S/N 687Cancelled Sep 15, 2009 · Triennial form not returned · Portsmouth, NH N7445UBoeing 727-222 · S/N 21899Cancelled Sep 15, 2009 · Second triennial form not returned · Built 1979 · Newington, NH N7446UBoeing 727-222 · S/N 21900Cancelled Sep 15, 2009 · Triennial form not returned · Built 1979 · Portsmouth, NH N7449UBoeing 727-222 · S/N 21903Cancelled Sep 15, 2009 · Triennial form not returned · Built 1979 · Portsmouth, NH N7456UBoeing 727-222 · S/N 21910Cancelled Sep 15, 2009 · Triennial form not returned · Built 1980 · Newington, NH N7458UBoeing 727-222 · S/N 21912Cancelled Sep 15, 2009 · Triennial form not returned · Built 1980 · Portsmouth, NH N7464UBoeing 727-222 · S/N 21918Cancelled Sep 15, 2009 · Triennial form not returned · Built 1980 · Portsmouth, NH N536PABritish Aerospace BAE JETSTREAM 3101 · S/N 681Cancelled Dec 31, 2008 · Exported to Haiti · Nashua, NH N508PABritish Aerospace BAE JETSTREAM 3101 · S/N 674Cancelled Oct 10, 2006 · Exported to Dominican Republic · Built 2001 · Newington, NH N369PABoeing 727-200 · S/N 21950Cancelled Oct 3, 2006 · Triennial form not returned · Built 1980 · Portsmouth, NH N522PABritish Aerospace BAE JETSTREAM 3101 · S/N 663Cancelled Oct 3, 2006 · Triennial form not returned · Portsmouth, NH

Back to Pan Am Railways Inc