Skip to content

Cancelled registrations · 223

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 = 'IL' AND d.registrant_city = 'ROCKFORD' 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 = 'IL' AND d.registrant_city = 'ROCKFORD'
  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 = 'IL' AND d.registrant_city = 'ROCKFORD'
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.

N96275Taylorcraft BC12-D · S/N 8575Cancelled Feb 15, 2025 · Sale reported, canceled · Built 1946 N9798YBeech 35-B33 · S/N CD-619Cancelled Oct 28, 2023 · Revoked, canceled · Built 1963 · Donneaud Kenneth B N513WKSchleicher ASH25M · S/N 25263Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 2006 · Muser Michael N82876Aeronca 7AC · S/N 7AC-1526Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1946 · Newhouse Hayden Victor N131MCBeech B-60 · S/N P-392Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1976 · Seven Oaks Leasing LLC N32605Piper J3L-65 · S/N 5483Cancelled Jul 31, 2021 · Revoked, canceled · Built 1940 · Carraher James L N368EABeech 400A · S/N RK-57Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1992 · Wild Aviation LLC N1272EAeronca 7AC · S/N 7AC4830Cancelled Mar 22, 2021 · Revoked, canceled · Built 1946 · Lindeman Burdette V N8413ABeech A35 · S/N D-1891Cancelled Dec 11, 2020 · Registration pending, canceled N505JSSiebel James A AURIGA · S/N 005Cancelled Dec 9, 2020 · Built 2002 · Siebel James A N350CDSchaefer Eugene G QUICKSILVER MXL · S/N QS6447EGSCancelled Feb 28, 2020 · Registration expired, pending cancellation · Schaefer Eugene G N71362Luscombe 8A · S/N 2789Cancelled May 6, 2019 · Revoked, canceled · Built 1946 · Johnson Gordon T N5006CBeech B35 · S/N D-2268Cancelled Mar 11, 2019 · Revoked, pending cancellation · Built 1950 · Welch Laverne G N557VCDJI PHANTOM 2 VISION · S/N PH636148264Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Carlson Scott E N848SGGill Scott M QUICKSILVER MXII · S/N 1730Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1985 · Gill Scott A N18WHHunt-Wallace T-18 · S/N 342Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Hunt Wallace G N2502VCessna 170 · S/N 18005Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Built 1948 · Buford John T N426RACessna 150E · S/N 15060989Cancelled Apr 2, 2018 · Revoked, canceled · Built 1965 · Rockford Air Charter Inc N426QBeech 65 · S/N LC-63Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 1960 · Ingram Dalton N1251MPiper PA-32-260 · S/N 32-1033Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1968 · Buford John T N4235BBeech F35 · S/N D-4208Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1955 · Rock Valley College N565CHDaub Kenneth R PAWNEE CHIEF · S/N PC00002Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 2005 · Clear Horizons Inc N6648BFlying K Enterprises SKYRAIDER · S/N 09970153Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1997 · Kramer Bruce N9646UGrumman American Avn. AA-1C · S/N AA1C0084Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1977 · Harast William G N76HGLockheed 1329 · S/N 5076Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1966 · Rubloff Jetstar 731 LLC N68ATArctic S-1B2 · S/N 1019Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1981 · Harast William G N8033BCessna 172 · S/N 29833Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1957 · Pripps Seth D N73615Fairchild M-62 · S/N T424143Cancelled Nov 21, 2017 · Revoked, canceled · Built 1942 · Birks James S Jr N7684TCessna 172A · S/N 47284Cancelled Nov 21, 2017 · Revoked, canceled · Built 1960 · Northern Illinois Aviation Inc N51309Fairchild M-62A · S/N T435600Cancelled Nov 18, 2017 · Revoked, canceled · Built 1943 · Winsett Joe N6764RCessna T210F · S/N T210-0164Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1966 · Rock Valley College N125NAHarmenings High Flyers DELUXE · S/N 006008Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Asner Nesher G N3076CBeech K35 · S/N D-5741Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1959 · Penniman Kevin M N300RDGrumman G-1159 · S/N 3Cancelled May 22, 2017 · Registration expired, pending cancellation · Built 1968 · Rubloff 300 LLC N195MRHernden Michael R THORP T-18 · S/N 180Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Hernden Michael Jr N726RAHartwig BREEZY STOLBATIC · S/N BS-1Cancelled Feb 4, 2017 · Revoked, canceled · Built 1971 · Dow Charles N86298Floyd PDQ-2VW · S/N 2117752Cancelled Feb 4, 2017 · Revoked, canceled · Built 1976 · Floyd David R N3728SCessna 172E · S/N 17250928Cancelled Jul 11, 2016 · Third renewal notice · Built 1963 · Bowler William E N7000Lockheed 18 · S/N 2556Cancelled Dec 2, 2014 · Revoked, canceled · Built 1952 · Fly Safe Ltd Inc N70662Piper J3C-65 · S/N 17682Cancelled Dec 2, 2014 · Revoked, canceled · Built 1946 · Blackhawk Flying Club N711USPeck P-1 · S/N P-1Cancelled Dec 2, 2014 · Revoked, canceled · Peck Norman O N6835DCougar D1-M · S/N DC161C904FCancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1961 · Butchart Marshall G N911BKMBB BK 117 A-3 · S/N 7099Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Rockford Memorial Hospital N64412Stinson L-5 · S/N 2004Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1943 · Morris Donna Lee A N56311Piper PA-28-140 · S/N 28-7325606Cancelled Oct 28, 2014 · Registration expired, pending cancellation · Built 1973 · Nappi Tito C DBA N1283GNorth American T-28B · S/N 138218Cancelled Sep 9, 2014 · Exported to New Zealand · Morgan John P N46294Brown James C 1990 STEEN SKYBOLT · S/N SB-1990Cancelled Oct 18, 2013 · Registration expired, pending cancellation · A26 Europe Inc N66702Cessna 150M · S/N 15076220Cancelled Sep 26, 2013 · Revoked, canceled · Built 1974 · Rao Subhash R Dr N8758SCessna 150F · S/N 15062058Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1965 · Shellenberger Richard O N66375Cessna 150M · S/N 15075999Cancelled Sep 25, 2013 · Revoked, canceled · Built 1974 · Nelson David C

Back to Rockford, IL