Cancelled registrations · 30

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

N64LFKepple PITTS SPECIAL S1 · S/N 751-HCancelled May 6, 2019 · Registration expired, pending cancellation · Foster Lanse P N3158KMooney M-18L · S/N 2Cancelled Mar 23, 2018 · Revoked, canceled · Built 1948 · Brew Sidney C N96KRKidd Chris HARMON ROCKET 2 · S/N 2001Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 2001 · Kidd Chris N39562Jones Robert T QUICKSILVER MX II · S/N 1385Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Jones Robert T N94369Engineering & Research ERCOUPE 415-C · S/N 1592Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1946 · Linn John C N207EWWilliams Evrett R LANCAIR 235 · S/N 207Cancelled Apr 17, 2007 · Triennial form not returned · Williams Everett R N74476Bellanca 14-13-3 · S/N 1615Cancelled Apr 4, 2000 · Triennial form not returned · Williams Everett R N7075WPiper PA-28-180 · S/N 28-857Cancelled Oct 19, 1981 · Billingsley Lee H N7181YPiper PA-30 · S/N 30-205Cancelled Oct 19, 1981 · Miller Grant C N6933QBeech 19A · S/N MB-294Cancelled May 11, 1981 · Spangler William G N2573HErcoupe 415-C · S/N 3198Cancelled Feb 25, 1971 · Jaske Robert J N43124Taylorcraft BC12-D · S/N 6783Cancelled Sep 1, 1970 · Bailey Douglas W N4140LCessna 172G · S/N 17254209Cancelled Jun 8, 1970 · West Side Aero Club N3904VCessna 170 · S/N 18214Cancelled Jun 2, 1970 · Hildebrand W L N31840Aeronca 65-TL · S/N 6821TCancelled May 25, 1965 · Daniel David Norman N53728Fairchild PT-19B · S/N T43-5746Cancelled Dec 9, 1955 · Built 1943 · Billingsley L H N47920Fairchild M-62A · S/N 7773AECancelled Nov 15, 1955 · Hudson Reginald Eugene Or Fred Charles Linder N66814Fairchild M-62C(PT-23A) · S/N 283-H0Cancelled Oct 24, 1955 · Smith Irving K N39701Waco UPF-7 · S/N 5833Cancelled Jul 27, 1951 · Built 1942 · Jamieson T N76502Cessna 120 · S/N 10934Cancelled May 8, 1951 · Jamieson T L N3110HEngineering & Research ERCOUPE 415-C · S/N 3735Cancelled Jan 30, 1950 · Built 1946 · Watkins R B Et Al N640CStinson 108-3 · S/N 108-3640Cancelled Jun 16, 1949 · H Robert Dykes Jr N8773KStinson 108-1 · S/N 108-1773Cancelled Jun 16, 1949 · Jamieson T L N89296Cessna 140 · S/N 8322Cancelled May 25, 1949 · Jamieson T L N48930Ryan Aeronautical ST3KR · S/N 1875Cancelled Nov 12, 1948 · Hudson Charles S N1290EAeronca 7AC · S/N 7AC-4850Cancelled Jul 10, 1947 · Jamieson Jay N2328Swallow Airplane Mfg SWALLOW LAND PLANE · S/N 809Cancelled Jun 1, 1939 · Bush Clarence Edward N655KCessna DC-6A · S/N 225Cancelled Sep 24, 1937 · Bush C E N10611Walker Nolan G NORTHROP GLIDER · S/N 1Cancelled Jan 12, 1933 · Walker Nolan G N1079International F-17 · S/N 14Cancelled Jan 7, 1933 · Macsween M & Pollard D

Back to Taft, CA