Skip to content

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 = 'LA' AND d.registrant_city = 'KENNER' 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 = 'LA' AND d.registrant_city = 'KENNER'
  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 = 'LA' AND d.registrant_city = 'KENNER'
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.

N323RDRobinson Helicopter R44 II · S/N 13591Cancelled Nov 6, 2023 · Exported to Canada · Built 2013 · State Machinery & Equipment Acquisitions LLC N4782WRockwell International 114 · S/N 14112Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1976 · Flaptacular LLC N1905CLyons Robert APACHE 582 · S/N 4267Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 2006 · Silversten Bryan J N202SMRobinson Helicopter R44 II · S/N 12277Cancelled Mar 5, 2022 · Registration expired, pending cancellation · State Machinery & Equipment Acquisition LLC N25900Cessna 152 · S/N 15280843Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1977 · Alcaine Manuel Enrique N314TWhittman Tailwind W-8 · S/N 1-T0Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1965 · Occhipinti Anthony C N6713ZBeech 77 · S/N WA-62Cancelled Nov 14, 2014 · Registration expired, pending cancellation · Built 1979 · Brightway Leasing Inc N162RMMartin Bob SPECTRUM RX550 · S/N SB2497Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Martin Robert D N2127NBell Helicopter Textron 206L-1 · S/N 45626Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1981 · Helicopter Charter Inc N320SEEhlers Craig S LANCAIR 320 · S/N 620-320-365FBCancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1993 · Ehlers Craig S N8492ZCessna 210-5A(205A) · S/N 205-0492Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1963 N4467WBeech 95-B55 (T42A) · S/N TC-1680Cancelled Nov 9, 2012 · Sale reported, canceled · Built 1974 N18FBCessna 210-5A · S/N 205-0564Cancelled Aug 13, 2012 · Registration expired, pending cancellation · Built 1964 · Air Salvador Inc N7217LBeech C-99 · S/N U-226Cancelled Jul 19, 2012 · Registration expired, pending cancellation · Lexpress Inc N84623Cessna 172K · S/N 17258550Cancelled May 2, 2007 · Triennial form not returned · Built 1969 · Mammelli Frank J Sr N52ESLockheed PV-1 · S/N 5497Cancelled Sep 29, 2004 · Sale reported · Built 1955 N26REBoos R D / Boos E C CHALLENGER II · S/N CH2 0891 CW0719Cancelled Nov 18, 2002 · Triennial form not returned · Built 1991 · Boos Richard D N6413YPiper PA-23-250 · S/N 273704Cancelled Oct 25, 1991 · Exported to Antigua and Barbuda · Bayou Consultants N35JSMartin 404 · S/N 14162Cancelled May 2, 1991 · Triennial form not returned · C & S Specialties Inc N3660VCessna 150M · S/N 15076576Cancelled Dec 23, 1981 · Built 1975 · Transit Aviation Of Lake Charles Inc N8805MBeech 95-B55 · S/N TC-615Cancelled Mar 11, 1974 · Exported to Kenya · Twinam Captain Doug D N2323BGlobe GC-1B · S/N 3623Cancelled Jul 3, 1969 · James R Stonecypher N944BBell 47G · S/N 678Cancelled Aug 19, 1957 · Exported to Guatemala · General Air Transport Inc N55221Taylorcraft DCO-65 · S/N L-5596Cancelled Nov 30, 1955 · Aeronautical Club Of New Orleans

Back to Kenner, LA