Skip to content

Cancelled registrations · 64

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 = 'SLIDELL' 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 = 'SLIDELL'
  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 = 'SLIDELL'
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.

N204NCNoel Cusimano GLASAIR 1 FT · S/N 204Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Cusimano Matthew E N24254Pearson Michael A PEARSON DREAM 2000 · S/N 001Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 2005 · Pearson Michael A N4299CPiper PA-34-220T · S/N 34-8333086Cancelled Mar 8, 2023 · Built 1983 · Air Reldan Inc N5022YPiper PA-23-250 · S/N 27-2026Cancelled Nov 3, 2022 · Registration expired, pending cancellation · Built 1962 · Moore Douglas W N633WBQuicksilver SPORT 2S · S/N SPORT 2S 0190Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Audibert Gill J N990MGBeech 95-B55 (T42A) · S/N TC-1439Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 1972 · Bates James L Jr N797NTDJI PHANTOM 3 STANDARD · S/N PP7ADCL11W100VWCancelled Feb 28, 2020 · Registration expired, pending cancellation · Gilbert Paul S N797VGDJI INSPIRE 1 RAW · S/N W21ADC23020234Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Gilbert Paul S N797XTDJI PHANTOM 3 4K · S/N P7ADCL11W100VWCancelled Feb 28, 2020 · Registration expired, pending cancellation · Gilbert Paul S N1660CQuicksilver Manufacturing SPORT 2S · S/N 0167Cancelled Dec 13, 2019 · Registration pending, canceled · Built 2006 N7740GDJI PHANTOM 3 STANDARD · S/N P5ADCG06030055Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Gilbert Paul N35167Cessna 177B · S/N 17702243Cancelled Mar 5, 2019 · Exported to Russia · Built 1975 · M10 Aviators LLC N9316LAmerican AA-1A · S/N AA1A-0016Cancelled Sep 18, 2018 · Registration expired, pending cancellation · Built 1971 · Cooper Melvin E Jr N9158SBeech C23 · S/N M-1774Cancelled Jul 12, 2018 · Sale reported, canceled · Built 1976 N5112RBeech B19 · S/N MB-646Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1974 N6549RBeech B19 · S/N MB-717Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1974 N6785ACessna P172D · S/N P17257178Cancelled May 3, 2018 · Registration expired, pending cancellation · Built 1963 · Doell Daniel A N9522VMooney M10 · S/N 700012Cancelled Apr 4, 2018 · Registration expired, pending cancellation · Built 1969 · M10 Aviators LLC N9071VMooney M20E · S/N 690012Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 1968 · Dauzat Dean N94462Cessna 152 · S/N 15285681Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1982 · Samrow Perry N118DCBeech M35 · S/N D-6548Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1960 · Herbert Veronica L N96866Taylorcraft BF · S/N 9166Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Mitchell Ned T N8176GCarrigan Sean SKYRANGER EX-1 · S/N 1796Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Carrigan Sean P N7890BBenson Robert L JR Q-2 · S/N 1Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1996 · Benson Robert L Jr N2155DBeech D35 · S/N D-3505Cancelled Sep 8, 2016 · Registration pending, canceled · Built 1953 N7MCBeech 65-A90-1 · S/N LM-106Cancelled Aug 29, 2016 · Built 1968 · St Tammany Parish Mosquito Abatement District N7781JPearson Michael Adrian SONERAI II · S/N 988Cancelled Oct 21, 2013 · Registration expired, pending cancellation · Pearson Michael A N746CEPiper PA-31-310 · S/N 31-195Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1968 · L & K Tool Company Inc N26CWWoods VP-1 · S/N 073Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1977 N8946MBeech 35-B33 · S/N CD-707Cancelled Jul 17, 2013 · Sale reported, pending cancellation · Built 1963 N58KHHuete Kenneth G QUICKSILVER MX II · S/N 1426Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Huete Kenneth Gerald N9468UCessna 150M · S/N 15078416Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1976 · Keating Aviation Inc N62REEverson SIDEWINDER · S/N 212039Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1977 · Pearson Michael A N444ZHCessna 172N · S/N 17268502Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Underwood Louis A N40990Piper PA-28-151 · S/N 28-7415127Cancelled Nov 19, 2012 · Registration expired, pending cancellation · Built 1974 · Keating Lionel J N82CHHooper Charles O GLASAIR SH-2 · S/N 132Cancelled Jun 28, 2011 · Registration pending, canceled · Built 1982 N302CAAnnaloro Camillo JR C A SPCL QUICKSILVER · S/N GT500-0052Cancelled May 24, 2010 · Triennial form not returned · Built 1995 · Annaloro Camillo Jr N15614Piper E-2 · S/N 294Cancelled Jul 30, 2009 · Registration revoked · Built 1935 · Mitchell Ned T N89VEVidrine Everett E DRAGONFLY · S/N 906Cancelled Apr 9, 2009 · Triennial form not returned · Built 1988 · Hilliard Frank L N9882TCessna 172A · S/N 47682Cancelled Nov 24, 2008 · Triennial form not returned · Built 1960 · Moran Donald E Jr N893MAMooney M-20G · S/N 680114Cancelled Sep 29, 2008 · Triennial form not returned · Built 1968 · Quinn Carl E Jr N88UFMoreau Raymond L CONDOR III+2 500 · S/N 83-121-3-2Cancelled Aug 15, 2008 · Triennial form not returned · Moreau Raymond DBA N8134YMaxwell Allan J JR SEARAY · S/N 1MK193Cancelled Nov 13, 2007 · Triennial form not returned · Built 1998 · Maxwell Allan J Jr N894DMLively Lanier D THUNDER GULL J · S/N DL01Cancelled Jun 25, 2007 · Triennial form not returned · Built 1994 · Lively Lanier D N7363RWartenburg David L COYOTE II S-6ES · S/N 4163Cancelled Jan 28, 2003 · Triennial form not returned · Wartenburg David L N4850BCessna 152 · S/N 15283672Cancelled Jan 8, 2002 · Triennial form not returned · Built 1979 · Slidell Aviation Services Inc N214JGBede BD-5B · S/N 214Cancelled May 9, 2001 · Guidry Jeffrey David N36TBBabbitt Leonard WEEDHOPPER · S/N TB001Cancelled Dec 9, 1999 · Triennial form not returned · Babbitt Leonard N7394JWartenburg David S-12XL AIRAILE · S/N 09970816Cancelled Aug 26, 1998 · Wartenburg David N70718Hallal C/Hallal M CHALLENGER II · S/N CH20292W0797Cancelled Dec 9, 1996 · Triennial form not returned · Hallal Charles

Back to Slidell, LA