Skip to content

Cancelled registrations · 46

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_state = 'PA' AND d.registrant_city = 'MORTON' 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_state = 'PA' AND d.registrant_city = 'MORTON'
  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_state = 'PA' AND d.registrant_city = 'MORTON'
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.

N8MFFairbanks PATM-299 · S/N 1Cancelled Nov 6, 1992 · Triennial form not returned · Fairbanks Anthony M N9071HGoodyear S-30 · S/N P1Cancelled Sep 20, 1991 · Triennial form not returned · Balloon Club Of America N9074HGoodyear S-94 · S/N P4Cancelled Sep 20, 1991 · Triennial form not returned · Balloon Club Of America N69450Platt Lepage XR 1A · S/N 2Cancelled Feb 24, 1971 · Revoked, pending cancellation · Built 1945 · Piasecki Helicopter Corp N4636GVertol 107-II · S/N 457Cancelled Oct 7, 1970 · Exported to Canada · Built 1964 · Boeing Co N4638GVertol 107-II · S/N 409Cancelled Oct 7, 1970 · Exported to Canada · Boeing Co N6679DBoeing-Vertol 107-II · S/N 11Cancelled Feb 5, 1970 · Exported to Sweden · Boeing Co N74060Vertol 107 · S/N 69-1XCancelled Oct 8, 1965 · Built 1958 · Vertol Division N4635GBoeing Vertol V-107-II-14 · S/N 4012Cancelled Jul 1, 1965 · Exported to Canada · Built 1965 · Boeing Co N4634GBoeing Vertol V-107-II-14 · S/N 4011Cancelled Jun 29, 1965 · Exported to Canada · The Boeing Companyvertol Division N4633GBoeing Vertol V-107-II-14 · S/N 4010Cancelled May 17, 1965 · Exported to Canada · Built 1965 · Boeing Co N4631GBoeing Vertol V-107-II-14 · S/N 4008Cancelled May 14, 1965 · Exported to Canada · The Boeing Company Vertol Division N4632GBoeing-Vertol 107-II · S/N 4009Cancelled May 13, 1965 · Exported to Canada · The Boeing Co Vertol Division N4639GBoeing-Vertol 107-II · S/N 410Cancelled May 13, 1965 · Exported to Sweden · The Boeing Co Vertol Division N4630GBoeing-Vertol 107-II · S/N 4007Cancelled Feb 23, 1965 · Exported to Canada · The Boeing Co. Vertol Division N4629GBoeing-Vertol 107-II · S/N 10412Cancelled Feb 6, 1965 · Exported to Canada · Boeing Co N4627GBoeing-Vertol 107-II · S/N 10410Cancelled Jan 8, 1965 · Exported to Canada · Boeing Co Vertol Division N4628GBoeing Vertol V-107-II-14 · S/N 4005Cancelled Dec 15, 1964 · Exported to Canada · The Boeing Co Vertol Division N6685DBoeing Vertol BV 107-II-28 · S/N 4001Cancelled Dec 15, 1964 · Exported to Canada · Boeing Co N4626GBoeing Vertol V-107-II-14 · S/N 10409Cancelled Nov 18, 1964 · Exported to Canada · The Boeing Co Vertol Division N4625GBoeing Vertol V-107-II-14 · S/N 4002Cancelled Nov 12, 1964 · Exported to Canada · The Boeing Co N10100Vertol 44B · S/N 527Cancelled Aug 17, 1964 · Exported to Sweden · Boeing Co N10102Vertol 44B · S/N 529Cancelled Aug 17, 1964 · Exported to Sweden · Boeing Co N10103Vertol 44B · S/N 530Cancelled Aug 14, 1964 · Exported to Sweden · Boeing Co N10101Vertol 44B · S/N 528Cancelled Jun 26, 1964 · Exported to Sweden · Boeing Co N10104Vertol 44B · S/N 538Cancelled Jun 26, 1964 · Exported to Sweden · Boeing Co Vertol Div N6681DBoeing-Vertol 107-II-9 · S/N 302Cancelled May 13, 1964 · Exported to Canada · The Boeing Company Vertol Division N6680DBoeing-Vertol 107-II-9 · S/N 301Cancelled Apr 1, 1964 · Exported to Canada · The Boeing Company/ Vertol Division N10121Boeing 107-II-15 · S/N 503Cancelled Mar 31, 1964 · Exported to Sweden · Boeing Co N10112Boeing-Vertol 107-II-9 · S/N 303Cancelled Sep 19, 1963 · Exported to Canada · Boeing Co N10119Boeing 107-II-15 · S/N 501Cancelled Sep 19, 1963 · Exported to Sweden · The Boeing Co/Vertol Div N10122Boeing Vertol V-107-II-14 · S/N 304Cancelled Sep 19, 1963 · Exported to Canada · Boeing Co N10113Boeing Vertol V-107-II-14 · S/N 401Cancelled Aug 19, 1963 · Exported to Sweden · The Boeing Co/ Vertol Division N10105Vertol 44B · S/N 478Cancelled Feb 26, 1963 · Exported to Germany · Vertol Division/Boeing Airplane Co N6678DBoeing-Vertol 107-II · S/N 103Cancelled Apr 30, 1962 · Exported to Japan · Boeing Company Vertol Division N6671DBoeing-Vertol 107-II · S/N 1Cancelled Jan 11, 1962 · Built 1961 · Boeing Co N10108Vertol 44B · S/N RU1Cancelled Nov 25, 1960 · Exported to Russia · Vertol Division Boeing Airplane Co N10106Vertol 44A · S/N 146-1Cancelled Oct 28, 1960 · Exported to Germany · Built 1960 · Being Airplane Co N3913AVertol 42A · S/N B-120Cancelled Dec 16, 1958 · Vertol Aircraft Corp N3914AVertol 42A · S/N B-147Cancelled Dec 16, 1958 · Vertol Aircraft Corp N74056Vertol 44A · S/N 417Cancelled Dec 16, 1958 · Vertol Aircraft Corporation N74057Vertol 44B · S/N 418Cancelled Dec 16, 1958 · Vertol Aircraft Corp N74059Vertol 42A · S/N 439Cancelled Mar 27, 1958 · Exported to Canada · Vertol Aircraft Corporation N4200AVertol 42B · S/N 329 F 31Cancelled Apr 16, 1957 · Exported to France · Vertol Aircraft Corp N4201AVertol 42B · S/N 330 F 32Cancelled Apr 16, 1957 · Exported to France · Vertol Aircraft Corp N37061Piasecki PV-2 · S/N 1Cancelled Nov 10, 1955 · Built 1943 · Piasecki Helicopter Corp

Back to Morton, PA