Cancelled registrations · 21

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 = 'FOSTER CITY' 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 = 'FOSTER CITY'
  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 = 'FOSTER CITY'
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.

N3759DCessna 182A · S/N 34459Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 1957 · Chan Lawrence N756FYCessna R182 · S/N R18201068Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Tsai Jerry N989MVCessna 172S · S/N 172S11325Cancelled Sep 30, 2014 · Exported to Japan · Built 2013 · Terry Mcgee Aviation N7586SCessna 182Q · S/N 18265235Cancelled Jan 24, 2014 · Exported to Russia · Built 1976 · Mcgee Terry N73857Cessna 172N · S/N 17267725Cancelled Jul 16, 2013 · Exported to Russia · Built 1976 · Mcgee Terry N4305YPiper PA-23-160 · S/N 23-2028Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1962 · Chavossy Louis N41644Piper PA-28-151 · S/N 28-7415302Cancelled Nov 20, 2012 · Registration expired, pending cancellation · Built 1974 · Weldon Associates N216GGriffin MINIPLANE · S/N AG-1Cancelled Aug 24, 2012 · Registration expired, pending cancellation · Built 1971 · Maxwell Edward G N9364SBeech B24R · S/N MC-360Cancelled Mar 20, 2007 · Exported to Canada · Built 1975 · Roussard Harry N811CEMesserschmitt-Bolkow-Blohm BO 105LS A-3 · S/N 2036Cancelled Jul 29, 1999 · Blc Corporation N1396UCessna T210N · S/N 21064691Cancelled Jul 16, 1998 · Triennial form not returned · Long James N5308UCessna T210N · S/N 21064859Cancelled Jan 4, 1994 · Triennial form not returned · Long James A N402GNLockheed 188C · S/N 188C1085Cancelled Feb 26, 1993 · Integrity Aircraft Sales Inc N405GNLockheed 188A · S/N 188A1094Cancelled Feb 26, 1993 · Integrity Aircraft Sales Inc N664FLockheed 188A · S/N 1066Cancelled Feb 26, 1993 · Integrity Aircraft Sales Inc N93338Cessna T210L · S/N 21060367Cancelled Jan 22, 1985 · Administratively canceled · Dobbs William N1612XCessna T210L · S/N 21060648Cancelled Jul 14, 1977 · Olivero James L N3807QCessna U206F · S/N U20603032Cancelled Jul 2, 1976 · Exported to Australia · Built 1975 · United States Aviation Enterprises Inc N5177CBeech B35 · S/N D-2376Cancelled Dec 3, 1971 · Triano Frank N3103KSuperior CULVER V · S/N V-322Cancelled Dec 31, 1970 · Cease Stephen W N8101KUniversal Stinson 108-2 · S/N 108-3101Cancellation date not recorded · Built 1947 · Kramer Richard S

Back to Foster City, CA