Skip to content

Cancelled registrations · 72

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 JOLLA' 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 JOLLA'
  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 JOLLA'
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.

N625SEEmbraer EMB-135BJ · S/N 14500851Cancelled Dec 12, 2025 · Exported to San Marino · Built 2004 · Advanta Aviation Holdco II LLC N983JBombardier BD-700-1A10 · S/N 9072Cancelled Nov 12, 2024 · Built 2000 · Jacobs Irwin Mark Trustee N8716DPiper PA-22-160 · S/N 22-5897Cancelled May 13, 2023 · Built 1958 · Hubbard Eugene N N765UCAerial Imaging Solutionsllc APQ-18 · S/N 002Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Department Of Commerce N6584PAerial Imaging Solutions APH-22 · S/N 017Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Department Of Commerce N658XCAerial Imaging Solutions APH-22 · S/N 020Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Department Of Commerce N659CNAerial Imaging Solutions APH-22 · S/N 018Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Department Of Commerce N659JAAerial Imaging Solutions APH-22 · S/N 019Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Department Of Commerce N545HNAerial Imaging Solutions APH-22 · S/N 008Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Department Of Commerce N545JDAerial Imaging Solutions APH-22 · S/N 012Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Dept Of Commerce N581YBAerial Imaging Solutionsllc APQ-18 · S/N 001Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Department Of Commerce N543YAAerial Imaging Solutions APH-22 · S/N 007Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Dept Of Commerce N563SNAerial Imaging Solutions APH-22 · S/N 009Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Department Of Commerce N707DFCirrus Design SR22T · S/N 1621Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 2017 · John H Serocki Md N22371Aeronca 50-C · S/N C3709Cancelled May 11, 2020 · Sale reported, pending cancellation N637WCSensefly EBEE · S/N EB-03-22184Cancelled Jun 29, 2019 · Registration expired, pending cancellation · Regents Of The University Of California N28804Bowlus BA-100 · S/N 127Cancelled Nov 17, 2018 · Revoked, pending cancellation · Built 1940 · Bent Alfred E N5414PPersistence Mining ARMDS · S/N 012015Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Persistence Mining Inc N8521RBellanca 14-19-3 · S/N 4283Cancelled Jul 13, 2018 · Registration expired, pending cancellation · Built 1966 · Cusick Christopher J N111AYRose David L ROSE PERAGRINE 4 · S/N 101Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Rose David L Trustee N2225XCessna 337 · S/N 337-0125Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1965 · Turbo Wing International Inc N13NGRose David L ROSE PEREGRINE · S/N 101Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 1998 · Rose David L Trustee N7409NBalloon Works FIREFLY 7 · S/N F7-249Cancelled May 23, 2017 · Registration expired, pending cancellation · Spencer Douglas P N45LPLaister Sailplane Products LP-49 · S/N 45KCancelled May 13, 2015 · Registration expired, pending cancellation · Built 1972 · O Reilly James E N100EBMooney M22 · S/N 700003Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1970 · Goebel Cynthia N8640KUniversal Stinson 108-1 · S/N 108-1640Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1947 N8494SBornhorst-Wilson-O'Hagan HP-12A · S/N 80Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1980 · O Hagan Michael N93095Cessna 210L · S/N 21060259Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1974 · Kreis Max S N7464FHughes 269C · S/N 960535Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1976 · Kenram Corp N6126JPiper PA-32R-300 · S/N 32R-7680307Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1976 · River Rock Ranch Inc N54684Raven S55A · S/N S55A-166Cancelled Jan 30, 2013 · Sale reported, canceled · Built 1974 N50TEDassault-Breguet FALCON 10 · S/N 86Cancelled Nov 19, 2012 · Registration expired, pending cancellation · Built 1976 · Torrey Leasing Company N33690Piper PA-28-151 · S/N 28-7515311Cancelled Oct 4, 2012 · Registration expired, pending cancellation · Built 1975 · Stachowski Stephanie M N795PHartline John Bon HARTLN PULSAR 912 XP · S/N 385Cancelled Sep 6, 2012 · Registration pending, canceled · Built 1995 N192KWCessna 172C · S/N 17249122Cancelled Apr 8, 2010 · Triennial form not returned · Hall Donald M N112PGMawhinney Robert F GLASS GOOSE · S/N 995009Cancelled Jan 13, 2009 · Triennial form not returned · Built 2004 · Mawhinney Robert F N32AJGates Lear Jet 36A · S/N 36A048Cancelled Feb 16, 2006 · Exported to Germany · Built 1981 · Code Aviation LLC N844DSchempp-Hirth K. G NIMBUS II · S/N 22Cancelled May 16, 2003 · Triennial form not returned · Built 1972 · Ivans William S N70338Newman R E/Jones W RAF GTX SE · S/N H-2-97-8-320Cancelled Jul 9, 2002 · Built 1998 · Slifka Robert L N3NGMortensen MONG · S/N 101Cancelled May 1, 2002 · Triennial form not returned · Built 1998 · Rose David L N2809DRaven Industries S-60A · S/N S60A-403Cancelled Jul 9, 2001 · Triennial form not returned · Miller William R N15FFBeech K35 · S/N D-6045Cancelled Apr 9, 2001 · Triennial form not returned · Harrison Walter K Trustee N6184BCessna T210M · S/N 21062700Cancelled Jun 27, 2000 · Triennial form not returned · Hamburger Robert N Trustee N8100JBell 47G-3B-2 · S/N 6824Cancelled Feb 19, 1999 · Second triennial mailing, no response · Kozpla Fishing Corp N8436XPiper PA-28-161 · S/N 288116322Cancelled Jul 24, 1998 · Triennial form not returned · Trenton Ronald B N50287Cessna 150H · S/N 15069198Cancelled Jan 23, 1998 · Triennial form not returned · Shively Harold Hy N61788Evans William S EVANS VP 300 · S/N WE300Cancelled Aug 13, 1996 · Triennial form not returned · Evans William S N9074HBeech 95-B55 · S/N TC1200Cancelled Jan 23, 1996 · Exported to South Africa · Gow Kieth Henry N3792URodrequez A L KING COBRA · S/N 002Cancelled Jul 19, 1994 · Triennial form not returned · Rodriguez Abelardo L N6462NCessna T210N · S/N 21063036Cancelled Jan 3, 1986 · Turbo-Flite Inc

Back to La Jolla, CA