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 = 'MILL VALLEY' 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 = 'MILL VALLEY'
  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 = 'MILL VALLEY'
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.

N639MKYuneec International Q500 4K TYPHOON · S/N YU15211864B04B01Cancelled Dec 11, 2020 · Sale reported, canceled N3186GNorth American T-28A · S/N 49-1631ACancelled May 22, 2020 · Revoked, canceled · Built 1958 · Lake Melvin N461BDCessna 172N · S/N 17270418Cancelled Mar 22, 2017 · Built 1978 · Pickleweed Flying Club LLC N7625EDowner 14-19-3 · S/N 4127Cancelled Feb 4, 2017 · Revoked, canceled · Built 1959 · Williamson Lars F N645CFCessna 150E · S/N 15061303Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1965 · Charlie Foxtrot Limited N376CUniversal Stinson 108-2 · S/N 108-3376Cancelled Sep 18, 2012 · Revoked, canceled · Built 1949 · Williamson Lars F N4678NCessna T-50 · S/N 6212Cancelled Aug 1, 2012 · Revoked, canceled · Built 1943 · Luetke John R N26591Taylorcraft BF · S/N 1933Cancelled Jul 15, 2009 · Registration revoked · Built 1940 · Dean Alan D N1652APiper PA-22 · S/N 22-413Cancelled Jul 7, 2009 · Registration revoked · Built 1952 · Johnson Russell L N207MBCessna T207A · S/N 207-00589Cancelled Apr 21, 2008 · Exported to Chile · Built 1980 · Forty Degrees South N2232YFuessl Hans W FUESSL SCORPION · S/N 1Cancelled Jan 5, 2006 · Exported to Germany · Fuessl Hans W N625HCAviat A-1 · S/N 1192Cancelled Nov 21, 2005 · Exported to Argentina · Built 1991 · Forty Degrees South N881BMooney M20 · S/N 1044Cancelled Jun 29, 2005 · Triennial form not returned · Built 1957 · Freiburger Tom N8210Cessna 310 · S/N 35172Cancelled Apr 13, 2005 · Sale reported · Built 1955 N9487ECessna 172N · S/N 17272279Cancelled Apr 29, 2002 · Triennial form not returned · Built 1979 · San Francisco Seaplane Tours Inc N75SHBell 206B · S/N 1719Cancelled May 14, 2001 · Triennial form not returned · Hendricks Sidney J N7895MCessna TU206F · S/N U20602154Cancelled Feb 15, 2001 · Exported to Argentina · Forty Degrees South N206DGCessna TU206G · S/N U20606492Cancelled May 7, 1999 · Exported to Chile · Forty Degrees South N2900VChristen Industries A-1 · S/N 1021Cancelled Jan 23, 1995 · Exported to Chile · Forty Degrees South Inc N911DJCessna TU206G · S/N U20606705Cancelled Oct 21, 1993 · Exported to Chile · Forty Degrees South N2008MPiper PA-28R-201T · S/N 28R7803099Cancelled Mar 17, 1993 · Talley Richard P N9939MCullen/Roth FALCON XP · S/N 600203Cancelled Feb 26, 1992 · Triennial form not returned · Cullen William E DBA N8359HPiper PA-28RT-201T · S/N 28R8131100Cancelled Mar 28, 1991 · Triennial form not returned · Jansheski John E N5JGMercer OWL RACER · S/N JM1Cancelled Feb 4, 1991 · Triennial form not returned · Denton Harvey D N1552UCessna T207 · S/N 20700152Cancelled Sep 24, 1980 · Exported to Canada · Built 1969 · Padula Fred D N11RFBreezy RLU-1 · S/N 1Cancelled Oct 25, 1977 · Built 1970 · Gardiner John L N6465SCessna 150H · S/N 15067265Cancelled May 26, 1976 · Roskie Louis F N8036ACessna 170B · S/N 20888Cancelled Sep 3, 1974 · Built 1952 · Moore Jerry Ddba Golden Gate Graphics N4263TPiper PA-28-140 · S/N 28-7225109Cancelled Jun 21, 1974 · Built 1971 · Alan Shelmerdine Aircraft N4875Enstrom F-28A · S/N 26Cancelled Aug 28, 1973 · Exported to United Kingdom · Hurley Sheldon B DBA Commodore Helicopters N9378FHughes 269B · S/N 64-0094Cancelled Nov 13, 1967 · Built 1964 · Commodore Helicopters N99515Ercoupe 415-C · S/N 2138Cancelled Sep 11, 1958 · Built 1946 · Brezina Edward S N3897KTemco GC-1B · S/N 3597Cancelled Feb 18, 1957 · Built 1948 · Griffin C L N85NCurtiss JN4D · S/N D169047 SUBCancelled Mar 14, 1930 · Buckle Robert K

Back to Mill Valley, CA