Skip to content

Pacific Palisades, CA

Cancelled registrations · 34

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 = 'PACIFIC PALISADES' 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 = 'PACIFIC PALISADES'
  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 = 'PACIFIC PALISADES'
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.

N4537YGrumman American Avn. AA-5B · S/N AA5B1292Cancelled Dec 3, 2024 · Built 1979 · Thomas Christopher D N8929MBeech S35 · S/N D-7884Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 1965 · Trewhitt Douglas G N538AJDaniels J R/Price Gary BERKUT · S/N 011Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1996 · Snake River Aero LLC N885DTDg-Flugzeugbau DG-1000M · S/N 10-168M17Cancelled Feb 15, 2018 · Exported to Argentina · Built 2011 · Tito Dennis A N7008XCessna 150A · S/N 15059108Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1961 · Smith David P N121HJPiper PA-46-310P · S/N 468508105Cancelled Nov 21, 2014 · Registration expired, pending cancellation · Built 1985 · Kenosha LLC N5201FCessna T182T · S/N T18208152Cancelled Sep 30, 2013 · First renewal notice · Built 2002 · Bazar Dennis E N347VBeech 65-88 · S/N LP-24Cancelled Apr 16, 2013 · Registration expired, pending cancellation · Built 1966 · Ash Robert C N144PERobinson Helicopter R44 II · S/N 12183Cancelled Jan 7, 2013 · Exported to Philippines · Built 2008 · Icarus Copters LLC N4644WRockwell International 112TCA · S/N 13174Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1977 · Kakkar Hakumat Rai N7871CSchempp-Hirth STANDARD AUSTRIA S · S/N 21Cancelled Jun 8, 2011 · Registration pending, pending cancellation · Built 1962 N1MFCessna 421B · S/N 421B0872Cancelled May 14, 2010 · Triennial form not returned · Built 1975 · Russell Kurt V N80544Colich Milan T QCK SLVR GT 400 · S/N 1483Cancelled Mar 23, 2010 · Triennial form not returned · Colich Milan T N327DHAB Sportine Aviacija LAK-17A · S/N 116Cancelled Sep 16, 2009 · Exported to Canada · Huppertz Richard E N120CHEurocopter EC120B · S/N 1139Cancelled May 5, 2004 · Exported to Australia · Icarus Copters LLC N756PUCessna U206G · S/N U20604255Cancelled Mar 7, 2001 · Triennial form not returned · Freitas Albert B N43677S N I A S AS350D ASTAR · S/N 1382Cancelled May 2, 1997 · Exported to New Zealand · Berry Katherine S N701SHRobinson Helicopter R22 BETA · S/N 1701Cancelled Jan 28, 1995 · Triennial form not returned · Daniels John R N911PDHughes 269C · S/N 860539Cancelled Feb 17, 1994 · Exported to Netherlands Antilles · Corsair Copters Inc N25CTCessna 421B · S/N 421B0358Cancelled Feb 10, 1993 · Triennial form not returned · Momahon James T N7014ESchempp-Hirth DISCUS B · S/N 234Cancelled Jun 29, 1988 · Exported to Japan · Thomson Helen N9705RBeech M35 · S/N D-6235Cancelled Oct 29, 1974 · Bloomfield W E N4226BBeech F35 · S/N D-4195Cancelled Aug 8, 1969 · Tackla Kaufman N78395Aero Commander 680-F · S/N 680F-1289-132Cancelled Oct 1, 1963 · Exported to New Zealand · Air Ferry International Inc N94251Convair 240 · S/N 108Cancelled Sep 20, 1962 · Exported to Japan · Air Ferry International Inc N9502YBeech 65 · S/N LC-144Cancelled Aug 28, 1962 · Exported to Japan · Air Ferry International N9503YBeech 65 · S/N LC-145Cancelled Aug 28, 1962 · Exported to Japan · Air Ferry International N9504YBeech 65 · S/N LC-146Cancelled Aug 28, 1962 · Exported to Japan · Air Ferry International N94228Convair 240 · S/N 53Cancelled May 24, 1962 · Exported to Japan · Air Ferry International Inc N93117Douglas DC-6B · S/N 45060Cancelled Apr 2, 1962 · Exported to Japan · Air Ferry International N9197ZDouglas DC3 · S/N 4436Cancelled Apr 10, 1961 · Exported to Japan · Air Ferry International N491Douglas DC3 · S/N 2185Cancelled Mar 29, 1961 · Exported to Japan · Air Ferry International N353ZBeech G18S · S/N BA-551Cancelled Nov 22, 1960 · Exported to Japan · Air Ferry International N63466Cessna T-50 · S/N 5557Cancellation date not recorded · Bland John Lilburn Jr

Back to Pacific Palisades, CA