Skip to content

Victorville, CA

Cancelled registrations · 42

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

N386FEMcdonnell Douglas MD-10-10F · S/N 46620Cancelled Apr 13, 2024 · Sale reported, canceled · Built 1973 N387FEMcdonnell Douglas MD-10-10F · S/N 46621Cancelled Apr 13, 2024 · Sale reported, canceled · Built 1974 N556FEMcdonnell Douglas MD-10-10F · S/N 46710Cancelled Apr 13, 2024 · Sale reported, canceled · Built 1972 N569FEMcdonnell Douglas MD-10-10F · S/N 47828Cancelled Apr 13, 2024 · Sale reported, canceled · Built 1980 N68050Mcdonnell Douglas MD-10-10F · S/N 47804Cancelled Apr 13, 2024 · Sale reported, canceled · Built 1974 N640BCMcdonnell Douglas MD-11F · S/N 48756Cancelled Feb 16, 2021 · Sale reported, canceled N747GEBoeing 747-121 · S/N 19651Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1970 · General Electric Co N183YPPiasecki/Pike Joseph W PV-18 · S/N 18-1Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1951 · Pike Joseph William N975ASMcdonnell Douglas DC-9-83(MD-83) · S/N 53451Cancelled Jul 7, 2015 · Sale reported · Built 1994 N944JDCessna TU206G · S/N U20603536Cancelled May 13, 2015 · Registration expired, pending cancellation · Felix Ignacio Jr N514DABoeing 727-232 · S/N 21430Cancelled Apr 23, 2015 · Registration expired, pending cancellation · Built 1978 · Pacific Aviation Group LLC N529DABoeing 727-232 · S/N 21703Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1979 · Pacific Aviation Group LLC N4855EYoung David E QUICKSILVER MXLSPORT · S/N 023Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1987 · Young David E N7457UBoeing 727-222 · S/N 21911Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1980 N8816SCessna 150F · S/N 15062116Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1965 N93SWBoeing 737-2H4 · S/N 22965Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1983 N76VPCessna 150G · S/N 15065547Cancelled Jul 15, 2013 · Sale reported, canceled · Built 1966 N37949Aiello George QUICKSILVER MX · S/N 1198Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1983 N4202NHammons John M TEENIE TWO · S/N 15-1573Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Lair Rex N31RMMurray Ronald D RV-6A · S/N 22882Cancelled May 21, 2013 · Registration expired, pending cancellation · Built 1998 · Graham Roger N7266UBoeing 727-222 · S/N 21413Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1978 N5201BMooney M20 · S/N 1064Cancelled Sep 12, 2012 · Sale reported, pending cancellation · Built 1956 N5SHBrodie MUSTANG II · S/N 484Cancelled Aug 10, 2012 · Revoked, canceled · Built 1976 · Brodie James E N100VWCessna T-50 · S/N 5577Cancelled Jul 19, 2012 · Registration expired, pending cancellation · Built 1943 · Lair Rex N109APBoeing 737-205 · S/N 21445Cancelled Apr 26, 2010 · Triennial form not returned · Pacific Aviation Group LLC N434TJChristen Industries PITTS S-2S · S/N 3010Cancelled Nov 26, 2008 · Triennial form not returned · Just Timothy W N7465UBoeing 727-222 · S/N 21919Cancelled Sep 12, 2007 · Triennial form not returned · Built 1980 · Pacific Aviation Group LLC N5LTCessna 210 · S/N 57033Cancelled Apr 5, 2007 · Second triennial mailing, no response · Built 1959 · Ada Leasing Inc N1014AVicent Alfred LONG-EZE · S/N 1014Cancelled Nov 21, 2006 · Built 1986 · Bauer John L N7453UBoeing 727-222 · S/N 21907Cancelled Sep 22, 2006 · Triennial form not returned · Built 1979 · Pacific Aviation Group LLC N7462UBoeing 727-222 · S/N 21916Cancelled Sep 21, 2006 · Triennial form not returned · Built 1980 · Pacific Aviation Group LLC N5122UCessna 206 · S/N 206-0122Cancelled Jul 15, 2005 · Exported to Mexico · Built 1964 · Chalk 2 LLC N99590Ercoupe 415-C · S/N 2213Cancelled Oct 25, 2003 · Triennial form not returned · Built 1946 · Caspary Robert L N7271PBoeing 727-30 · S/N 18933Cancelled Jun 9, 2003 · Exported to Swaziland · Built 1965 N4406Cessna U-3A · S/N 575894Cancelled Jan 11, 1999 · Triennial form not returned · Victor Valley College N20VVBell 47G-2 · S/N 1897Cancelled Jan 9, 1999 · Triennial form not returned · Victor Valley Community College Dist N3559APiper PA-22-135 · S/N 22-1833Cancelled Dec 31, 1970 · Hartman Ronald E N3512HEngineering & Research 415-CD · S/N 4137Cancelled May 20, 1965 · T W Phinney N99102Ercoupe 415-C · S/N 1725Cancelled May 20, 1964 · Smith William C N67272Cessna T-50 · S/N 5460Cancelled Feb 7, 1962 · Exported to Costa Rica · Williams Markle Q N5159VBeech T-34A · S/N 53-3329ACancelled Jan 12, 1960 · George Afb Aero Club N8627KCessna 150 · S/N 108-1627Cancelled Nov 8, 1955 · Geraldine Masinter

Back to Victorville, CA