Skip to content

Cancelled registrations · 95

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 = 'WI' AND d.registrant_city = 'KENOSHA' 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 = 'WI' AND d.registrant_city = 'KENOSHA'
  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 = 'WI' AND d.registrant_city = 'KENOSHA'
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.

N810AKDJI INSPIRE 1 PRO · S/N W21ACL04020602Cancelled Jan 14, 2023 · Registration expired, pending cancellation · Aeroworks Productions LLC N404JJJames A Jacobsen CHALLENGER II · S/N 001Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Jacobsen James A N803UVDJI INSPIRE 1 · S/N W13DCA13020131Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Ifly Media Productions LLC N31136Robinson Helicopter R44 II · S/N 14388Cancelled Sep 27, 2021 · Midwestern Helicopter LLC N18655Cessna 150L · S/N 15074018Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1972 · Stick & Rudder LLC N2549XMueller Robert E N3-PUP · S/N 040199Cancelled Jan 31, 2020 · Registration expired, pending cancellation · Built 2001 · Levonowich Michael J N685QAero Commander 685 · S/N 12038Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Dejan Thomas W N65721Colgate George E CHALLENGER II SPEC · S/N CH20589CW0428Cancelled Jan 3, 2020 · Sale reported, canceled N1880BCessna T182T · S/N T18209078Cancelled Oct 4, 2019 · First renewal notice · Built 2012 · Deininger Colleen N5051JBellanca 8KCAB · S/N 525-79Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1979 · Bruns William F N601HARobinson Helicopter R22 · S/N 0107Cancelled Feb 1, 2019 · Registration expired, pending cancellation · A-Z Leasing LLC N2318XRobinson Helicopter R22 BETA · S/N 2029Cancelled Jan 28, 2019 · Registration expired, pending cancellation · Built 1991 · Lakeshore Helicopter LLC N73MAMitsubishi MU-2B-40 · S/N 414 SACancelled Jun 20, 2018 · Ra Aircraft Management Inc N819AKDJI Innovations INSPIRE 1 · S/N W13DBL26020318Cancelled Apr 24, 2018 · Second renewal notice · Aeroworks Productions LLC N1585APiper PA-20 · S/N 20-810Cancelled Mar 23, 2018 · Revoked, canceled · Built 1951 · Alpine Foods Ltd N5473ZPiper PA-22-108 · S/N 22-9254Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1962 · Stick & Rudder LLC N84637Aeronca 7AC · S/N 7AC3345Cancelled Feb 27, 2018 · Revoked, pending cancellation · Built 1946 · Priess Erhard N999ZDRobinson Helicopter R44 II · S/N 11108Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 2006 · Midwestern Air Services LLC N701KMFairchild C-123 · S/N 54-0701Cancelled Dec 15, 2016 · Third renewal notice · Kenosha Military Museum N810AKYuneec Electric TORNADO H920 · S/N YU15280081B03A01Cancelled Aug 25, 2016 · Aeroworks Productions LLC N61717Quicksilver MXL II · S/N 92101Cancelled May 13, 2016 · Third renewal notice · Built 1992 · Borths Jamie C N4894CBuckeye Industries EAGLE · S/N 4782Cancelled Jul 16, 2015 · Sale reported, pending cancellation · Built 1999 N4648PPiper PA-23-250 · S/N 27-169Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1960 · Gateway Technical College N3960NMooney M-20G · S/N 680067Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1968 · Delta Flying Club Of Kenosha Inc N492KMSikorsky HH-3F · S/N 1492Cancelled May 11, 2015 · Registration expired, pending cancellation · Kenosha Military Museum N3786DDyrhovd David A TIERRA II · S/N 3449773Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1983 · Dyrhovd David A N278GTAmerican Champion 7ECA · S/N 137098Cancelled Jun 4, 2014 · Exported to Canada · Built 1998 · Gateway Technical College N31138Robinson Helicopter R44 II · S/N 11313Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 2006 · Midwestern Helicopter LLC N301MDBell UH-1H · S/N 68-16301Cancelled Jul 30, 2013 · Sale reported, canceled N914MFFischer Michael P SONERAI IIL · S/N 1153Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Fischer Michael P N74523Mooney M20B · S/N 1834Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1961 · Hansen Todd M N906KMGrumman OV-1D · S/N 67-18906Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1967 · Kenosha Military Museum N6490GCessna 150K · S/N 15071990Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1970 · Hebert Michael N5679CCessna 140A · S/N 15635Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1950 · Caudill Kelly N57CTTodd Charles II KITFOX · S/N 287Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1997 · Todd Charles M N61200Cessna 150J · S/N 15070884Cancelled Apr 10, 2013 · Revoked, pending cancellation · Built 1969 · Slover George W N6433VCessna 172RG · S/N 172RG0694Cancelled Apr 3, 2013 · Exported to Brazil · Built 1980 · Stick & Rudder LLC N66365Cessna 172P · S/N 17275987Cancelled Jan 31, 2013 · Sale reported, canceled N5461MCessna 152 · S/N 15284591Cancelled Jan 29, 2013 · First renewal notice · Built 1980 · Aviation Plus LLC N446KMSikorsky CH-54A · S/N 68-18446Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Kenosha Military Museum N4327TPiper PA-28-140 · S/N 28-7125615Cancelled Nov 9, 2012 · Sale reported, canceled · Built 1971 N145PFCessna R182 · S/N R18200375Cancelled Oct 19, 2012 · Exported to Paraguay · Built 1978 · Acme Air Venture Inc N517BLMullis Robert Dale ZENAIR CH300 · S/N 300BMCancelled Sep 18, 2012 · Registration expired, pending cancellation · Mullis Robert D N22989Piper J3F-65 · S/N 2897Cancelled Sep 4, 2012 · Registration expired, pending cancellation · Built 1939 · Sorenson Paul W N12043Halsmer Safety Twin 3 · S/N 543211Cancelled Jun 4, 2012 · Sale reported, canceled · Built 1967 N53SCSteiner PITTS S2E · S/N K-0027Cancelled May 18, 2012 · Exported to Russia · Built 1984 · Acme Air Venture Inc N8563HNorth American NAVION A · S/N NAV-4-615Cancelled Oct 15, 2004 · Exported to Canada · Built 1947 · Jonczyk Robert J N244MLNeely Buddy R FLIGHT STAR II · S/N 174Cancelled Oct 29, 2002 · Triennial form not returned · Built 1997 · Levonowich Michael J N2217LBeech B24R · S/N MC-444Cancelled May 2, 2002 · Triennial form not returned · Built 1976 · Dejno'S Inc N869MInman EAA ACROSPORT · S/N 357Cancelled May 16, 1996 · Triennial form not returned · Willkomm John C

Back to Kenosha, WI