Skip to content

Cancelled registrations · 32

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

N868VPAgusta A109S · S/N 22120Cancelled May 20, 2024 · Exported to India · Built 2009 · Cargo Solutions Management LLC N52346Taylorcraft DCO-65 · S/N 5307Cancelled Jan 13, 2024 · Sale reported, canceled · Built 1943 N68288Cessna 152 · S/N 15282230Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Nyende James N5911FDJI PHANTOM 2 · S/N PH645282180Cancelled May 3, 2022 · Registration expired, pending cancellation · Fontana Police Dept N5975DDJI PHANTOM 2 · S/N PH645343535Cancelled May 3, 2022 · Registration expired, pending cancellation · Fontana Police Department N789WPCessna 210H · S/N 21059008Cancelled Aug 2, 2021 · Exported to Bolivia · Built 1968 · Flores Alex Aponte N85437Aeronca 7AC · S/N 7AC-4177Cancelled Jun 5, 2020 · Revoked, canceled · Built 1946 · Casey Charles L N7142ACessna 172 · S/N 29242Cancelled Feb 21, 2018 · Registration expired, pending cancellation · Built 1956 · Quintero Noel N56597Fairchild M-62A · S/N T41728Cancelled Nov 21, 2017 · Revoked, canceled · Built 1941 · Casey Charles L N6593BMooney M20A · S/N 1263Cancelled May 14, 2015 · Sale reported, canceled · Built 1958 N7882TCessna 172A · S/N 47482Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1960 · Latham Jack W N54KRBoncquet Herman RAND KR2 · S/N 5342Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1983 · Boncquet Herman N6613SCessna 150H · S/N 15067413Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1967 · Cuatote Abel J N1441XPiper PA-28-140 · S/N 28-7525315Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1975 · Klink James E DBA N1524Menees LP-49MS · S/N 1-9Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1971 · S.A.L. Management Inc N28321Sears Howard MITCHELL B-10 · S/N P1141Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Latham Jack W N5LMMcrorey Loelan J BEDE-5 · S/N 3186Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Mcrorey Loelan J N4EFCessna 150F · S/N 15064335Cancelled Jul 27, 2011 · Revoked, canceled · Built 1966 · Figwood Edward A N41384Piper PA-28-140 · S/N 28-7425234Cancelled Feb 28, 2011 · Revoked, pending cancellation · Built 1974 · Jordan William F N403MABell 222U · S/N 47516Cancelled Oct 21, 2010 · Triennial form not returned · Mercy Air Service Inc N408MABell 222B · S/N 47135Cancelled Oct 21, 2010 · Triennial form not returned · Built 1983 · Mercy Air Service Inc N94153Engineering & Research 415-C · S/N 1476Cancelled Sep 17, 2009 · Registration revoked · Built 1946 · Cozad Donald P N184TACessna T182T · S/N T18208111Cancelled Apr 18, 2006 · Triennial form not returned · Built 2001 · Mcleod Equipment Leasing LLC N26WWWasowski Walter J ACRODUSTER TOO SA750 · S/N 977WW1Cancelled Mar 2, 1996 · Triennial form not returned · Wasowski Walter J N84766Sherman Richard W TURBULENT · S/N RWS-2Cancelled Nov 7, 1992 · Registration expired, pending cancellation · Built 1986 · Mcrorey Loelan J N9609ACessna 140A · S/N 15330Cancelled Sep 11, 1972 · Built 1949 · O'Neal James H And /Or O'Neal Colleen P N6724MStinson 108-3 · S/N 108-4724Cancelled Feb 28, 1972 · Elfstrom Donald N53655Fairchild M-62A · S/N T43-7128Cancelled Jun 26, 1970 · Haaland Clarence Eugene N68211Fairchild M-62A-3 · S/N T43-4522Cancelled May 22, 1965 · Bell Bill N33973Taylorcraft BC12-65 · S/N 2825Cancelled Feb 20, 1956 · Built 1941 · Wellman Jems F Jr N8357KStinson 108-1 · S/N 108-1357Cancelled Oct 17, 1955 · Built 1947 · Wierman Maraget N577MWaco ATO · S/N 3003Cancelled Jan 14, 1955 · Stotelmyre M J

Back to Fontana, CA