Cancelled registrations · 39

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

N6058BCessna 182A · S/N 34058Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1957 · Sommerville Rex L N77801Luscombe 8A · S/N 3528Cancelled May 4, 2019 · Revoked, pending cancellation · Built 1946 · Savoie Robert J N8472MCessna A150K · S/N A15000172Cancelled May 21, 2018 · Revoked, canceled · Built 1970 · Kelly Alfred M N3346GPiper PA-19 · S/N 18-2139Cancelled Mar 16, 2018 · Revoked, canceled · Camp Irwin Flying Club N678BDDepue Bill E SKY RAIDER II · S/N 052Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 2007 · Depue Bill E N4048DCessna 182A · S/N 34748Cancelled Jul 29, 2014 · Built 1957 · Sommerville Rex L N67084Piper J3C-65 · S/N 8277-13Cancelled May 31, 2013 · Sale reported, canceled · Built 1942 N5664SBeech A23-19 · S/N MB-94Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1966 · Bilnoski Lloyd K N54491Gokey SCORPION II · S/N BG-1Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1978 · Gokey William J N407BBeech 35 · S/N D-1412Cancelled Mar 7, 2013 · Sale reported, pending cancellation · Built 1948 N16JKKurpell BARNETT J-4-B GYROPL · S/N 038Cancelled Oct 15, 2012 · Registration expired, pending cancellation · Built 1977 · Kurpell Joseph J N4874CDouglas DC-7 · S/N 44264Cancelled Aug 8, 2012 · Revoked, canceled · Built 1954 · Midair Incorporated N3235LCessna 172H · S/N 17256135Cancelled May 21, 2012 · Built 1967 · Riley Michael L N9718CLockheed 1049E/01 · S/N 4549Cancelled Sep 18, 2009 · Registration revoked · Built 1959 · Midair Inc N10570Howard Dixon B B-8M · S/N 1Cancelled Nov 14, 2002 · Second triennial mailing, no response · Howard Dixon B N6538TCessna 150 · S/N 17938Cancelled Aug 16, 1995 · Triennial form not returned · Depue Bob G N2615UTaylor Earle L CHEROKEE II · S/N 5991Cancelled Mar 22, 1991 · Triennial form not returned · Taylor Earle L N3670APiper PA-22-135 · S/N 22-1929Cancelled Mar 12, 1982 · Harris Ernest M Et Al N1204UCessna 172M · S/N 17266903Cancelled Nov 2, 1977 · Paul R Spickler N8152NPiper PA-28-140 · S/N 28-25346Cancelled Dec 10, 1976 · Edwards Gilbert S N4876CDouglas DC-7 · S/N 44680Cancelled Oct 6, 1975 · Midair Inc N4877CDouglas DC-7 · S/N 44681Cancelled Oct 6, 1975 · Midair Inc N4878CDouglas DC-7 · S/N 44682Cancelled Oct 6, 1975 · Midair Incorporated N4881CDouglas DC-7 · S/N 44435Cancelled Oct 6, 1975 · Midair Inc N4884CDouglas DC-7 · S/N 45313Cancelled Oct 6, 1975 · Midair Incorporated N4886CDouglas DC-7 · S/N 45350Cancelled Oct 6, 1975 · Midair Incorporated N5402VLockheed 1049H-82 · S/N 4842Cancelled Jan 20, 1975 · Midair Inc N5403VLockheed 1049H · S/N 4844Cancelled Jan 20, 1975 · Midair Inc N1006CLockheed 1049H-82 · S/N 4802Cancelled Jan 17, 1975 · Midair Inc N1008CLockheed 1049H-82 · S/N 4806Cancelled Jan 17, 1975 · Midair Inc N37208Interstate S-1A · S/N 50Cancelled Feb 5, 1971 · Built 1941 · Hill Kenneth Etal N6722CNavion L-17B · S/N 48-1040Cancelled Sep 24, 1970 · United States Army N792BBeech A35 · S/N D-1804Cancelled Jun 25, 1970 · Moore James T N66480Howard DGA-15P · S/N 29489Cancelled Jun 18, 1970 · Warren C Hiffel N83750Aeronca 7AC · S/N 7AC-2428Cancelled Jun 12, 1970 · Taylor Dean D N9509KStinson 108-2 · S/N 108-2509Cancelled May 26, 1965 · Waldon Ivan O N9140ACessna 170A · S/N 18901Cancelled Jan 7, 1953 · B & H Auto Sales N414WTravel Air 12-Q · S/N 12Q-2027Cancelled Oct 27, 1935 · Russell E Riley N3885American Eagle A-1 · S/N 88Cancelled Jul 23, 1928 · Bauer And Slaton

Back to Barstow, CA