Cancelled registrations · 24

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 = 'LA PORTE' 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 = 'LA PORTE'
  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 = 'LA PORTE'
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.

N7956QCessna 310Q · S/N 310Q0676Cancelled Jun 5, 2025 · Sale reported · Built 1973 N86297Aeronca 11AC · S/N 11AC-103Cancelled Aug 22, 2024 · Built 1946 · Mcdannel Albert M N2071EDraves Richard J CGS HAWK CLASSIC · S/N HF-10Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Built 1993 · Draves Richard J N3709PPiper PA-22-150 · S/N 22-3427Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Built 1955 · Roebuck Michael H N250AAmbriole BABY ACE · S/N 1Cancelled Aug 7, 2020 · Registration pending, canceled · Built 1958 N47328Taylorcraft DCO-65 · S/N 5172Cancelled Jan 10, 2020 · Revoked, canceled · Built 1943 · Powers Carroll R N28BLCorey K Bonnell S-12S · S/N 05030971Cancelled May 9, 2017 · Exported to Argentina · Built 2014 · Sport Flight Inc N721JLDJI PHANTOM 3 PROFESSION · S/N P76DCI18A21011Cancelled Mar 27, 2017 · Landwerlen John N201RBBelzowski Richard BD-4 · S/N 2679Cancelled Jun 30, 2016 · Built 2005 · Belzowski Richard N600RTStaudacher S-600 · S/N 16Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1994 · Red Thunder Airshows Inc N6779Bergeron DER JAGER · S/N 178Cancelled May 14, 2015 · Sale reported, canceled N9090RReel William L V-STAR · S/N 515DCancelled May 7, 2015 · Registration expired, pending cancellation · Roebuck Michael H N4433TPiper PA-28-180 · S/N 28-7205162Cancelled Mar 22, 2010 · Second triennial form not returned · Built 1972 · Laporte Aviation Services Inc N34USPiccard AX-6 · S/N 634Cancelled Sep 18, 2003 · Built 1972 · Medley Grover C N1197LPrice Ronald M R A F 2000 · S/N H2-96-7-252Cancelled Aug 27, 2003 · Triennial form not returned · Built 1997 · Price Ronald M N4MLLamb SONERAI II-S2-MLI · S/N 18Cancelled May 2, 2001 · Sale reported N60GWWhite Philip C GOLDWING · S/N 60Cancelled Nov 20, 1998 · Triennial form not returned · Parrett Marlin N61ACBlatter Richard PITTS S2S · S/N 001Cancelled Mar 19, 1997 · Rux J S N6881MStinson 108-3 · S/N 108-4881Cancelled Jan 9, 1986 · Simcox Norman N1306VRazor Rautenstrauch GOODYEAR RACER LR2 · S/N 1Cancelled Jan 4, 1971 · Reeg Randolph L N956CBeech C-45H · S/N AF-720Cancelled Jan 24, 1968 · La Porte Aircraft Corp N4657ACessna 180 · S/N 32254Cancelled Nov 14, 1960 · Exported to Costa Rica · Hopkins Fred A N92346Piper J3C-65 · S/N 16800Cancelled Oct 13, 1955 · Rameier Dale Landon N424MStinson SM-8A · S/N 4042Cancelled Jan 1, 1941 · De Munck Gerard

Back to La Porte, IN