Skip to content

Noblesville, IN

Cancelled registrations · 38

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 = 'IN' AND d.registrant_city = 'NOBLESVILLE' 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 = 'IN' AND d.registrant_city = 'NOBLESVILLE'
  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 = 'IN' AND d.registrant_city = 'NOBLESVILLE'
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.

N111VPGene Knight T10 AIR BENDER · S/N 001T10ABCancelled Dec 3, 2022 · Registration expired, pending cancellation · Gordon Jim N1436CPiper PA-22-135 · S/N 22-1191Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1953 · Podzielinski Eric J N822RGGopro KARMA · S/N E5112324526756Cancelled Dec 5, 2020 · Registration expired, pending cancellation · International Disaster Emergency Service Inc N4319APiper PA-22-150 · S/N 22-3671Cancelled Sep 6, 2019 · Sale reported, canceled N3809Precision Drone PACESETTER · S/N DA000099Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Precision Drone LLC N543NSPrecision Drone PACESETTER · S/N DA000179Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Sheller D Adam N3464MPiper PA-12 · S/N 12-2071Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1947 · Mills Lyn J N94090Ercoupe 415-C · S/N 1413Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Gordon Terry L N789BCAvian Balloon SKYHAWK · S/N 112Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Paull Philip D N20623Cameron Balloons US N-65 · S/N 5420Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1988 · Menchhofer Jeff N22405Cessna T210L · S/N 21059742Cancelled May 13, 2014 · Exported to Mexico · Built 1972 · Indy Aircraft Inc N88539Piper J3C-65 · S/N 16165Cancelled Dec 16, 2013 · Exported to Australia · Built 1946 · Terrell Douglas E N7112ZBalloon Works FIREFLY 7-B · S/N F7B-138Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1987 · Menchhofer Donald L N3771DBalloon Works FIREFLY 7 · S/N F7-177Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1984 N4436PHunting Percival JET PROVOST 3A · S/N XN595Cancelled Aug 8, 2013 · Sale reported, canceled N8570DPiper PA-18A 150 · S/N 18-6226Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1957 · Ebert Fredrick L N4395ERaven S-60A · S/N S60A-315Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1984 · Above And Beyond Balloon Co N5571BRaven S55A · S/N S55A-550Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1979 · Above And Beyond Balloon Co N761GJCessna T210M · S/N 21062243Cancelled Feb 20, 2013 · Sale reported, pending cancellation N5671HPiper PA-16 · S/N 16-282Cancelled Jan 31, 2013 · Sale reported, canceled · Built 1949 N9664CCessna T303 · S/N T30300199Cancelled Nov 27, 2012 · Sale reported, pending cancellation · Built 1983 N6537RCessna T182T · S/N T18208315Cancelled Jul 30, 2008 · Exported to Panama · Built 2004 · Mmks Equipment Sales & Leasing LLC N1265JRockwell International 112A · S/N 265Cancelled Nov 1, 2007 · Exported to Canada · Built 1975 · Herider Jack N8238BBeaver Brad AIR BIKE · S/N AB68Cancelled Sep 27, 2004 · Triennial form not returned · Built 1998 · Beaver Brad D N72081Beaver Brandon D QUICKSILVER MX II · S/N 1584Cancelled Jul 14, 2000 · Triennial form not returned · Beaver Brandon D N310CBCameron Balloons O-65 · S/N 557Cancelled Jan 10, 1998 · Triennial form not returned · Newell Patrick F N74007Cameron Balloons O-65 · S/N 5103Cancelled Nov 22, 1993 · Triennial form not returned · Newell Patrick F N3685GBalloon Works FIREFLY 8-24 · S/N F8018Cancelled Sep 12, 1991 · Triennial form not returned · Balloonport Of Indiana N6417ZCessna TU206G · S/N U206-06272Cancelled Oct 8, 1985 · Exported to Panama · Indianapolis Aviation Inc N18851Burrow SIDEWINDER · S/N 212210Cancelled Jan 7, 1976 · Burrow Donald L N1GNBeech 95-B55 · S/N TC 1326Cancelled Feb 14, 1974 · Exported to Canada · Gus B Nuckols N8605EBensen B-8 GYRO-COPTER · S/N 25Cancelled Jan 13, 1971 · Wilson Clifford W N8606EBensen B-8 GYRO-COPTER · S/N 26Cancelled Jan 12, 1971 · Zinn Victor E N7507ULockheed T-33A · S/N 51-9023Cancelled Aug 6, 1970 · Noblesville School Corp N98488Piper J3C-65 · S/N 18691Cancelled May 21, 1965 · Eller Van John Wilder N8696HNorth American NAVION · S/N NAV-4-696Cancelled Nov 3, 1960 · Stony Creek Stone Co Inc N51917Fairchild M-62A · S/N T42-3754Cancelled Dec 6, 1955 · Built 1942 · Nobleville Flying Service Inc N16710Piper J-2 · S/N 718Cancellation date not recorded · Built 1936 · Porter Don D & Davis Robert S

Back to Noblesville, IN