Skip to content

Cancelled registrations · 40

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 = 'IA' AND d.registrant_city = 'DUBUQUE' 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 = 'IA' AND d.registrant_city = 'DUBUQUE'
  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 = 'IA' AND d.registrant_city = 'DUBUQUE'
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.

N831JHSkymaster Powered Parachutellc SKYMASTER EXCEL · S/N 00111Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Haupert John C N9126VPiper PA-46-310P · S/N 4608087Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1987 · Grand River Emergency Department Consultants LLC N75562Cessna 172N · S/N 17267811Cancelled Feb 14, 2017 · Exported to Mexico · Built 1976 · B & E Leasing LLC N5209ZCessna 172R · S/N 17281119Cancelled Dec 23, 2016 · Exported to Canada · Built 2002 · Kennedy Thomas L N95372Piper PA-28-140 · S/N 28-25904Cancelled Sep 13, 2016 · Registration expired, pending cancellation · Built 1969 · Wagner Robert J N52717Cessna 182P · S/N 18262794Cancelled Feb 27, 2015 · Exported to Russia · Built 1974 N4084PRaven S55A · S/N S55A-999Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1983 · Flights Of Fantasy Ltd N7033RRohner Steven M TIERRA II · S/N 622103Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Rohner Steven M N9872ACessna 190 · S/N 7574Cancelled Aug 7, 2013 · Exported to Australia · Built 1950 · Bockelman Michael G N5566SRaven Industries RALLY RX7 · S/N RX7-186Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1979 · Flights Of Fantasy Ltd N414ECPiper PA-28R-200 · S/N 28R-7335248Cancelled Nov 19, 2012 · Registration expired, pending cancellation · Built 1973 · Coursey Wayne M DBA N4113Aviat A-1 · S/N 1349Cancelled Sep 21, 2012 · Exported to Canada · Built 1997 · Martin George D N16231Piper PA-28-140 · S/N 28-7325227Cancelled Aug 9, 2012 · Registration expired, pending cancellation · Built 1973 · Midwest Aircraft Corporation N9735ACessna 170A · S/N 19196Cancelled Apr 10, 2012 · First renewal notice · Built 1949 · Hirsch Dale A N45571Cessna 150M · S/N 15076975Cancelled Jan 4, 2012 · Exported to Brazil · Built 1975 · B&E Leasing LLC N13868Cessna 172M · S/N 17263024Cancelled Jul 26, 2010 · Triennial form not returned · Built 1974 · Fitch William R N2723RQuicksilver SPORT II · S/N 000633Cancelled Jul 31, 2009 · Built 1997 · Wagner Stephen J N95382Cessna 172R · S/N 17280763Cancelled May 19, 2009 · Exported to Canada · Built 1999 · University Of Dubuque N597TBSocata TB-20 TRINIDAD · S/N 1817Cancelled Oct 7, 2008 · Triennial form not returned · Built 1997 · University Of Dubuque N89761Cessna 152 · S/N 15282856Cancelled Mar 28, 2006 · Exported to Canada · Built 1978 · University Of Dubuque N420JKCessna T210N · S/N 21063964Cancelled Sep 7, 2005 · Exported to Mexico · Built 1980 · B & E Leasing LLC N715HBCessna 172N · S/N 17273104Cancelled Jul 25, 2005 · Exported to Thailand · Built 1979 · University Of Dubuque N9248DPiper PA-22-160 · S/N 22-6308Cancelled Oct 9, 2002 · Built 1958 · Mcgovern Mark J N6617MCessna 152 · S/N 15284773Cancelled Oct 11, 2001 · Exported to Panama · Built 1980 · University Of Dubuque N3396SCessna 210J · S/N 21059196Cancelled Nov 3, 2000 · Mott Ken R N4FDWittman Tailwind W-8 · S/N 252Cancelled Mar 6, 1996 · Hedeman Donald L N8857SCessna 150F · S/N 15062157Cancelled Dec 7, 1993 · Triennial form not returned · Hirsch Dale A N9857VCessna 188 · S/N 1880107Cancelled Jul 29, 1991 · Triennial form not returned · Oj'S Crop Dusting Company N5205UCessna 206 · S/N 2060205Cancelled May 7, 1981 · Tri State Flyers Inc N8050ACessna 170B · S/N 20902Cancelled Nov 17, 1955 · Licht Kenneth N33743Aeronca 65-CA · S/N CA13221Cancelled Mar 24, 1954 · Exported to Canada · Built 1941 · Ehlers Fred A N47444Taylorcraft DCO-65 · S/N L-5100Cancelled May 3, 1951 · Oberfoell Sylvester J N92729Piper PA-12 · S/N 12-165Cancelled Apr 27, 1951 · Cedar Flying Service Inc N3620NPiper J3C-65 · S/N 22872Cancelled Feb 13, 1951 · Loras Hawks Inc N5080CBeech B35 · S/N D-2342Cancelled Oct 18, 1950 · Wynes-Dubuque Cp N95364Taylorcraft BC12-D · S/N 9764Cancelled May 11, 1949 · Cedar Flying Service Inc N97052Stinson 108-1 · S/N 108-1-1052Cancelled Jan 14, 1949 · Built 1946 · Poire Albert V.N12082Max Eggleston EGGLESTON · S/N 1Cancelled Dec 15, 1932 · Max Eggleston N251KHeath SUPER PARASOL · S/N P-215Cancelled Dec 15, 1932 · Hewins Herschel N243KDubuque Welding Works DUBUQUE PARASOL · S/N 28Cancelled Jun 6, 1930 · Hewins H

Back to Dubuque, IA