Skip to content

Cancelled registrations · 86

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

N308FPPorto Frank VARI EZE · S/N 622Cancelled May 27, 2023 · Registration pending, canceled · Built 2015 N60BWWilliams Robert B JR WILLIAMS MITE M18L · S/N 7Cancelled Apr 18, 2023 · Registration expired, pending cancellation · Henry Donald J N367SCDJI Innovations PHANTOM 3 PROFESSION · S/N P77DCE13010453Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Imagineit Group Inc DBA N4562UCessna 150D · S/N 15060562Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1964 · Anderson David P N243CCNorth American SNJ-4 · S/N 88-13243Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1943 · Bagdasarian Walter DBA N848SPScott Painter TAROT T15 · S/N T100Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Birds Eye Aerial Drones LLC N11784Kerr John L PIETENPOL GN-1 · S/N 1Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 1982 · Henry Donald J N869SPDJI INSPIRE 1 · S/N W13DCA23020251Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Birds Eye Aerial Drones LLC N267SPEvent38 E386 · S/N BK101Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Birds Eye Aerial Drones LLC N5656DAdcock John D KITFOX LITE · S/N L9812017Cancelled Aug 5, 2020 · First renewal notice · Adcock John D N386CCPiper/Cub Crafters PA-18-150 · S/N 9945CCCancelled Jun 15, 2020 · Exported to Canada · R & L West Group LLC N28481Luscombe 8A · S/N 1348Cancelled Sep 20, 2019 · Revoked, canceled · Built 1940 · Kennedy Peter C N694JDDJI PHANTOM 3 PROFESSION · S/N P76DCH30A20068Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Skyline Wesleyan Church Inc N319BMAir Tractor AT-802A · S/N 802A-0160Cancelled May 4, 2019 · Registration pending, canceled · Built 2003 N692USDassault-Breguet FALCON 10 · S/N 79Cancelled Apr 19, 2019 · First renewal notice · Built 1976 · Bagdasarian Walter N774GBDJI INSPIRE 1 · S/N W13DCA16020308Cancelled Jan 9, 2019 · Registration expired, pending cancellation · Buzel Gary N53616Laister-Kauffman TG-4A · S/N 35Cancelled Sep 13, 2018 · Revoked, canceled · Built 1942 · Girard Peter F N37480Cessna 414 · S/N 414-0958Cancelled May 30, 2018 · Sale reported, canceled · Built 1977 N280JMNorth American T-28C · S/N 226-166Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Bagdasarian Walter DBA N2515GLancair LC41-550FG · S/N 41090Cancelled Feb 15, 2018 · Sale reported, canceled N6500TCessna 150 · S/N 17900Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1960 · Martin Ronald L N1819EAeronca 7AC · S/N 7AC-5386Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Beaulieu Dennis J N849SPScott Painter TEAM BLACK SHEEP · S/N TBS100Cancelled Feb 24, 2016 · Birds Eye Aerial Drones LLC N17825Beech F33A · S/N CE-711Cancelled Jun 25, 2015 · Sale reported · Built 1977 N97JCPemberton JC DF-7 · S/N 1Cancelled Dec 1, 2014 · Registration expired, pending cancellation · Pemberton J C N6252CLee Terry W KOLB TWINSTAR · S/N M2-101Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1992 · Lee Terry W N737LWCessna 172N · S/N 17269510Cancelled Sep 22, 2014 · Sale reported, canceled · Built 1977 N51UNorth American P-51D · S/N 44-74204NCancelled Oct 31, 2013 · Registration expired, pending cancellation · Speer William A Jr N5439JCessna 421B · S/N 421B0898Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1975 · Mc Intyre Charles E N34CKFlaherty Ken ROTEC RALLY 3A · S/N 009558Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Flaherty Ken N8227QPiper PA-28RT-201 · S/N 28R-8018081Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1980 · Wellnitz Jerry Neil N4130ZPiper PA-15 · S/N 15-14Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Greenstone Mark W N87HKCirrus Design SR22 · S/N 0296Cancelled Mar 7, 2013 · Sale reported, canceled · Built 2002 N52600Cessna 182P · S/N 18262699Cancelled Dec 11, 2012 · Sale reported, canceled · Built 1973 N24961Cessna 152 · S/N 15280473Cancelled Sep 10, 2012 · Registration expired, pending cancellation · Built 1977 · Seabreeze Aeronautical Inc N27166Grumman American Avn. AA-5A · S/N AA5A0889Cancelled Aug 27, 2012 · Sale reported, canceled N4990VBeech C18S · S/N 8711Cancelled Aug 9, 2012 · Revoked, canceled · Amer&Can Investment Syndicate N6358DCessna 172N · S/N 17272744Cancelled Aug 8, 2012 · Exported to Mexico · Built 1979 · Rountree Gregory A DBA N1166QCessna T210L · S/N 21059666Cancelled Feb 3, 2011 · Exported to Mexico · Built 1972 N6882BCessna T210M · S/N 21062850Cancelled Mar 10, 2010 · Exported to Mexico N269KBeech D55 · S/N TE-501Cancelled Jul 22, 2009 · Exported to Brazil · Built 1967 · Bagdasarian Walter N4599UBeech 95-B55 (T42A) · S/N TC-1904Cancelled Oct 14, 2008 · Exported to Brazil · Built 1975 · Bagdajarian Walter DBA N1855ECessna 310R · S/N 310R1590Cancelled Nov 21, 2007 · Built 1979 · Bagdasarian Walter DBA N3648PPiper PA-22-150 · S/N 22-3399Cancelled Sep 18, 2007 · Triennial form not returned · Built 1955 · Pringle John R N8964LGrumman American Avn. AA-1B · S/N AA1B-0414Cancelled May 15, 2006 · Triennial form not returned · Built 1974 · Wilcox William Paul N8LCCook Louis G FISHER CELEBRITY · S/N AV1018Cancelled Apr 11, 2006 · Triennial form not returned · Built 1992 · Cook Douglas M N42BDSzybowcowy Zaklad Doswiadczaln 41A JANTAR STANDARD · S/N B-713Cancelled Jul 16, 2003 · Triennial form not returned · Built 1976 · Reith David N900SHClark Herb PITTS S1X · S/N 001Cancelled Jun 2, 2000 · Madden Mark S N396PBoeing/Alianelli/Prim A75-N1 · S/N 75-4395 APCancelled Apr 11, 2000 · Anianelli Richard N7403HCameron Balloons US N-160 · S/N 5135Cancelled Dec 8, 1998 · Prentice Mike DBA

Back to La Mesa, CA