Skip to content

Cancelled registrations · 138

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 = 'CO' AND d.registrant_city = 'LONGMONT' 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 = 'CO' AND d.registrant_city = 'LONGMONT'
  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 = 'CO' AND d.registrant_city = 'LONGMONT'
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.

N584RBRobinson Helicopter R44 II · S/N 12346Cancelled Aug 27, 2026 · Exported to Argentina · Colorado Jet Sales LLC N887LLTextron B200GT · S/N BY-319Cancelled Jan 24, 2025 · Exported to Argentina · Built 2018 · Colorado Jet Sales LLC N6082GCessna 150K · S/N 15071582Cancelled Feb 25, 2023 · Built 1969 · N738hd LLC N4423FPiper PA 46-350P · S/N 4636635Cancelled Jan 13, 2023 · Exported to Argentina · Built 2014 · Colorado Jet Sales LLC N1294UCessna 210N · S/N 21064683Cancelled Nov 21, 2022 · Exported to Argentina · Colorado Jet Sales LLC N1064BCessna T182T · S/N T18208797Cancelled Mar 17, 2022 · Exported to Argentina · Built 2007 · Colorado Jet Sales LLC N206NDDiamond Aircraft Ind DA20-C1 · S/N C0020Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 1998 · Kosair Inc N9907GCessna A150L · S/N A1500458Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Colorado Jet Sales LLC N6033NCessna T210M · S/N 21062901Cancelled Jun 23, 2021 · Exported to Argentina · Built 1978 · Colorado Jet Sales LLC N858GKPiper PA 46-350P · S/N 4636542Cancelled Feb 23, 2021 · Exported to Argentina · Built 2012 · Colorado Jet Sales LLC N89ERScheineman-Van Buren T-18 · S/N 1106Cancelled Jan 28, 2021 · First renewal notice · Built 1978 · Davis Jay N159SWPiper PA-31-350 · S/N 31-7405229Cancelled Mar 20, 2020 · Sale reported, canceled · Built 1974 N16419Monocoupe 90A · S/N A-747Cancelled Feb 28, 2020 · Sale reported, canceled · Built 1937 N6988NCessna T210N · S/N 21063197Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Built 1979 · Cag International Inc DBA N2038CBeech 95 · S/N TD-220Cancelled Nov 25, 2019 · Revoked, canceled · Built 1959 · Bren Walter A N927STUasusa TEMPEST · S/N 081715-1Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Uasusa LLC N7534CForney 415-CD · S/N 5649Cancelled Feb 9, 2019 · Revoked, canceled · Built 1958 · Dailey David Lynn N6844TWall Robert P CHALLENGER II · S/N CH2-0391-0657Cancelled Jan 9, 2019 · Registration expired, pending cancellation · Dedrick Raymond S N103THIron Ridge Engineering TERRAIN HAWK · S/N IRE-TH-1001Cancelled Dec 13, 2018 · Registration expired, pending cancellation · Iron Ridge Engineering LLC N3604GBalloon Works FIREFLY 7-B · S/N F7B-056Cancelled Dec 4, 2018 · Registration expired, pending cancellation · Whittaker Lance W N933ALLearjet 60 · S/N 316Cancelled Oct 17, 2018 · Exported to Argentina · Built 2007 · Colorado Jet Sales LLC N4790VBoeing E75 · S/N 75-5101Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1949 · Spears Aviation N73JBPiper PA-28R-200 · S/N 28R-7635013Cancelled Jun 4, 2018 · Built 1975 · Cag International Inc DBA N812SAeropro CZ S R O A240 · S/N 34712Cancelled May 31, 2018 · Sale reported, canceled · Built 2012 N145VSPipistrel VIRUS · S/N 360 VSW 100 LSACancelled May 30, 2018 · Sale reported, canceled · Built 2011 N24811Kolb FIRESTAR II · S/N F 1121Cancelled May 30, 2018 · Sale reported, canceled · Built 1997 N803RBeech K35 · S/N D-6003Cancelled Apr 18, 2018 · Built 1959 · Bennett Robert L Jr N25317Cessna 152 · S/N 15280590Cancelled Apr 13, 2018 · Exported to Argentina · Built 1977 · Colorado Jet Sales LLC N7477GCessna 150L · S/N 15074666Cancelled Apr 13, 2018 · Exported to Argentina · Built 1973 · Colorado Jet Sales LLC N500MSBeech E-90 · S/N LW-123Cancelled Mar 26, 2018 · Registration expired, pending cancellation · Built 1974 · Mile Hi Skydivers Inc N759QUCessna 182Q · S/N 18266182Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1977 · Cag International Inc DBA N628BSCessna 500 · S/N 500-0045Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1972 · Chippewa Aerospace Inc N1521TCessna 310Q · S/N 310Q0518Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1972 · Cag International Inc N33165Piper PA-28-140 · S/N 28-7525166Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1975 · Yost Alan N31288Balloon Works FIREFLY 8 · S/N F8-424Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1997 · Fair Winds Inc N12RVVogel Ronald C SKYBOLT · S/N 82939Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Vogel Ronald C N777GYCessna 320E · S/N 320E0027Cancelled Jul 14, 2017 · First renewal notice · Built 1968 · Left Hand Financial Inc DBA N495SCPiper PA-31-350 · S/N 31-8052062Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 1979 · Fowler Rick L N450JCLearjet 45 · S/N 45-070Cancelled May 3, 2017 · Exported to Argentina · Built 2000 · Colorado Jet Sales LLC N1248XMooney M20A · S/N 121Cancelled Feb 4, 2017 · Revoked, canceled · Built 1963 · Bren Walter A N6464Curtiss Wright TRAVEL AIR 4000 · S/N 785Cancelled Dec 22, 2016 · First renewal notice · Built 1928 · Murray Daniel J Trustee N155BJMcmurray David W F8L FALCO · S/N 934Cancelled Oct 6, 2016 · Exported to United Kingdom · Built 1994 · Mousouris Nick N824CChad Rennicke MM1 · S/N MM1CR1Cancelled Dec 21, 2015 · Built 2013 · Rennicke Chad N74023Grumman American Avn. AA-5B · S/N AA5B-0100Cancelled May 21, 2015 · Registration expired, pending cancellation · Built 1975 · Mckinny John N227ERAmerican General Acft AG5B · S/N 10114Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1992 · Dunlap Frederick S N89072Cessna 140 · S/N 8076Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1946 · Mckinny John C N733NACessna U206G · S/N U20604781Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1978 · C J Aviation L L C N133RKKeith Robert MINIBAT · S/N 133Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Keith Robert N58184Hughes Helicopters HUGHES 369D · S/N 280270DCancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1978 · Ag Air Incorp N26767Gulfstream American AA-5A · S/N AA5A0703Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1978 · Mckinny John

Back to Longmont, CO