Skip to content

Cancelled registrations · 564

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 = 'MN' AND d.registrant_city = 'CRYSTAL' 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 = 'MN' AND d.registrant_city = 'CRYSTAL'
  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 = 'MN' AND d.registrant_city = 'CRYSTAL'
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.

N73JHReed STARDUSTER TWO · S/N 166Cancelled Nov 1, 2019 · Sale reported, canceled · Built 1974 N33807Piper PA-28R-200 · S/N 28R-7535198Cancelled Oct 4, 2019 · Sale reported, canceled · Built 1975 N54JLLacher John H MUSTANG II · S/N 1776Cancelled Oct 4, 2019 · Sale reported, canceled · Built 1997 N858CDCirrus Design SR22 · S/N 0127Cancelled Oct 4, 2019 · Sale reported, canceled · Built 2001 N127AGRobinson Helicopter R22 BETA · S/N 0814Cancelled Sep 6, 2019 · Sale reported, canceled · Built 1988 N1561EAeronca 7AC · S/N 7AC-5124Cancelled Sep 6, 2019 · Sale reported, canceled · Built 1946 N2004UTaylorcraft F21 · S/N F-1006Cancelled Sep 6, 2019 · Sale reported, canceled · Built 1980 N402MYCessna 402B · S/N 402B0109Cancelled Sep 6, 2019 · Sale reported, canceled · Built 1971 N7924MBeech D95A · S/N TD-664Cancelled Sep 6, 2019 · Sale reported, canceled · Built 1966 N7973PPiper PA-24-250 · S/N 24-3210Cancelled Sep 6, 2019 · Sale reported, canceled · Built 1962 N80813Piper PA-28-161 · S/N 28-8016057Cancelled Sep 6, 2019 · Sale reported, canceled · Built 1979 N9058FCessna 177 · S/N 17700304Cancelled Aug 29, 2019 · Sale reported, canceled · Built 1967 N947SMCessna 172P · S/N 17274230Cancelled Aug 29, 2019 · Sale reported, canceled · Built 1980 N62611Beech M35 · S/N D6468Cancelled Jul 26, 2019 · Sale reported, canceled N786KSBeech C23 · S/N M-1676Cancelled Jul 9, 2019 · Sale reported, canceled · Built 1975 N9021BChampion 7FC · S/N 7FC-115Cancelled Jul 8, 2019 · Sale reported, canceled · Built 1957 N78745Cessna 172K · S/N 17257742Cancelled Jun 28, 2019 · Sale reported, canceled · Built 1968 N16171Cessna 150L · S/N 15073520Cancelled May 6, 2019 · Sale reported, canceled · Built 1972 N42143Cessna 182L · S/N 18258872Cancelled May 6, 2019 · Sale reported, canceled · Built 1968 N34462Cessna 177B · S/N 17701819Cancelled May 4, 2019 · Sale reported, canceled · Built 1972 N35170Cessna 177B · S/N 17702245Cancelled May 4, 2019 · Sale reported, canceled · Built 1975 N42588Reims CESSNA FR172F · S/N 0142Cancelled May 4, 2019 · Sale reported, canceled · Built 1969 N4594JPiper PA-28R-180 · S/N 28R-30470Cancelled May 4, 2019 · Sale reported, canceled · Built 1968 N6064VConsolidated Aeronautics LAKE LA-4-200 · S/N 790Cancelled May 4, 2019 · Sale reported, canceled · Built 1976 N9634TCessna 210 · S/N 57434Cancelled Apr 26, 2019 · Exported to Mexico · Built 1960 N4509FPiper PA-28-151 · S/N 28-7715044Cancelled Apr 24, 2019 · Sale reported, canceled · Built 1976 N5978GCessna 150K · S/N 15071478Cancelled Apr 22, 2019 · Sale reported, canceled N80399Cessna 172M · S/N 17266571Cancelled Apr 17, 2019 · Sale reported, canceled · Built 1976 N304MMPiper PA-32-300 · S/N 32-40588Cancelled Mar 20, 2019 · Exported to Philippines · Built 1969 N4231CCessna 414 · S/N 414-0531Cancelled Mar 9, 2019 · Sale reported, canceled · Built 1974 N6262JPiper PA-28R-200 · S/N 28R-7635329Cancelled Mar 9, 2019 · Sale reported, canceled · Built 1976 N6852UMooney M20C · S/N 2557Cancelled Mar 9, 2019 · Sale reported, canceled · Built 1963 N5523WPiper PA-28-150 · S/N 28-613Cancelled Feb 26, 2019 · Sale reported, canceled · Built 1962 N13197Cessna 172M · S/N 17262564Cancelled Feb 23, 2019 · Sale reported, canceled · Built 1973 N5622FAlon A2 · S/N A-222Cancelled Feb 7, 2019 · Sale reported, canceled · Built 1966 N41341Piper PA-28-151 · S/N 28-7415178Cancelled Feb 2, 2019 · Sale reported, canceled · Built 1974 N7164GCessna 172K · S/N 17258864Cancelled Feb 2, 2019 · Sale reported, canceled · Built 1969 N147VXEngineering & Research ERCOUPE 415-C · S/N 3832Cancelled Jan 29, 2019 · Sale reported, canceled · Built 1946 N2486DCessna 170B · S/N 20638Cancelled Jan 29, 2019 · Sale reported, canceled · Built 1952 N4156QCessna 310N · S/N 310N-0056Cancelled Jan 15, 2019 · Sale reported, canceled · Built 1968 N707RBCessna 182J · S/N 18257446Cancelled Jan 10, 2019 · Sale reported, canceled · Built 1966 N3939CCessna 310L · S/N 310L-0173Cancelled Jan 8, 2019 · Sale reported, canceled · Built 1967 N226EDLuther James H JR MURPHY REBEL · S/N 131RCancelled Dec 28, 2018 · Sale reported, canceled N334CMCirrus Design SR22 · S/N 0952Cancelled Dec 28, 2018 · Sale reported, canceled · Built 2004 N3308UCessna 182F · S/N 18254708Cancelled Dec 10, 2018 · Sale reported, canceled · Built 1963 N55095Piper PA-28-180 · S/N 28-7305310Cancelled Dec 10, 2018 · Sale reported, canceled · Built 1973 N80457Cessna 172M · S/N 17266596Cancelled Dec 10, 2018 · Sale reported, canceled · Built 1976 N9763KPiper PA-28-181 · S/N 28-7890178Cancelled Nov 17, 2018 · Sale reported, canceled · Built 1977 N5569GCessna 150J · S/N 15071069Cancelled Nov 2, 2018 · Sale reported, canceled · Built 1969 N8655TCessna 182C · S/N 52555Cancelled Nov 2, 2018 · Sale reported, canceled · Built 1960

Back to Crystal, MN