Cancelled registrations · 26

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

N6750KGrumman Acft ENG Cor-Schweizer G-164B · S/N 449-BCancelled Aug 8, 2023 · Valley Air Service N508CMMills Curtis A RV-8 · S/N 80698Cancelled Nov 21, 2022 · Registration expired, pending cancellation · Built 2000 · Yerxa Woodford A Trustee N3784VCessna 150M · S/N 15076622Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 1975 · Johnson Randy D N7358TCessna 172A · S/N 46958Cancelled Jun 3, 2021 · Third renewal notice · Built 1959 · East Colusa Farms N580TPCessna 210F · S/N 21058810Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1966 · Myers David H N7864CMitchell NIMBUS 3L · S/N 1Cancelled Feb 4, 2017 · Revoked, canceled · Built 1962 · Pechnik Enno N7568BChampion 7FC · S/N 7FC-70Cancelled Sep 3, 2014 · Sale reported, canceled · Built 1957 N3429PPiper PA-23-160 · S/N 23-1395Cancelled Jul 16, 2013 · Sale reported, canceled · Built 1958 N987XGrumman G-164A · S/N 512Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1968 · Millers Flying Service N8376Grumman Acft ENG Cor-Schweizer G-164A · S/N 868Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1971 · Millers Flying Service N3972YCessna 210D · S/N 21058472Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1964 · Foley Mickele A N10228Grumman G-164 · S/N 28Cancelled May 25, 2011 · Registration pending, canceled · Built 1959 N9088GCessna 182N · S/N 18260628Cancelled Jan 10, 1997 · Priority Trading Company N57419Boeing A75N1(PT17) · S/N 751662Cancelled Jun 22, 1994 · Triennial form not returned · Gimblin R S N64566Boeing 75 · S/N 757105Cancelled Jun 22, 1994 · Triennial form not returned · Gimblin R S N1208QCessna 150L · S/N 15072508Cancelled Jun 12, 1992 · Exported to India · Pearson Bryant D DBA N10221Grumman G-164 · S/N 21Cancelled Jul 29, 1977 · Davis Aviation Inc N1171NPiper J3L · S/N 10566Cancelled Jul 5, 1974 · Arnfield Jack Or Verla Arnfield N59106Cessna T-50 · S/N 4583Cancelled Jun 30, 1970 · Smith R J N477BBeech K35 · S/N D-5826Cancelled May 18, 1965 · W H Ohair Co N48095Aeronca 0-58B · S/N 058B-10113Cancelled Nov 25, 1955 · Built 1943 · Colusa Cloud Hoppers Inc N63528Consolidated Vultee BT-13A · S/N 6403Cancelled Oct 12, 1955 · Davis John W N81383Fairchild 24R-46 · S/N R46283Cancelled Oct 12, 1955 · Built 1946 · Davis Howell N56295Consolidated Vultee BT-13A · S/N 6119Cancelled Oct 11, 1955 · Davis John Wesley N8597HNorth American NAVION · S/N NAV-4-564Cancelled Feb 13, 1951 · Paulo Leon N602KTravel Air E-4000 · S/N 1246Cancelled Sep 27, 1944 · Harwick Donald Manfred

Back to Colusa, CA