Cancelled registrations · 156

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

N52678Cessna 182 · S/N 18262764Cancelled Apr 13, 1975 · Schneider Richard L N57663Cessna T-50 · S/N 4880Cancelled Oct 10, 1974 · Powers Norman D N2701BFoster DH-1 · S/N DH-1Cancelled Jul 23, 1974 · D H Foster N1360YCessna 172C · S/N 17249060Cancelled Apr 22, 1974 · Ostermaier Thomas S N18160Cessna 150L · S/N 15073833Cancelled Apr 22, 1974 · Richard L Schneider N10851Cessna 150L · S/N 15075088Cancelled Dec 5, 1973 · Gottschalk John F N8552NPiper PA-28-235 · S/N 28-11351Cancelled Oct 3, 1973 · Ewell George E Lois E Ewell N5863GCessna 150K · S/N 15071363Cancelled Oct 2, 1973 · Gottschalk John F N6524ZPiper PA-25 · S/N 25-2055Cancelled Jun 26, 1973 · Eastside Mosquito Abatement District N3862SCessna 172E · S/N 17251062Cancelled Aug 14, 1972 · Wilkinson Bill R / Natalia K Wilkinson N60934Cessna 150J · S/N 15070677Cancelled Jul 1, 1972 · John F Gottschalk N8667ZCessna P206C · S/N P206-0467Cancelled Mar 16, 1972 · John F Gottschalk N9412WPiper PA-28-235 · S/N 28-11119Cancelled Jan 14, 1972 · Ewell George E & Lois E Ewell N94939Taylorcraft BC12-D · S/N 9339Cancelled Aug 10, 1971 · Gerald D Conkle N1141BLuscombe 8A · S/N 5768Cancelled Dec 30, 1970 · Built 1947 · Corda Paul Et Al N5665KBeech S35 · S/N D-7597Cancelled Dec 30, 1970 · Kraus & Noonan Distributors Co N338CStinson 108-2 · S/N 108-3338Cancelled Sep 1, 1970 · Frazier James G N99765Ercoupe 415-C · S/N 2388Cancelled Jul 10, 1970 · Built 1946 · Greatorex Everett L N380HGreat Lakes 2T-1A · S/N 15Cancelled Jun 29, 1970 · Built 1930 · Parsons Clyde N75507Beech AT-11 · S/N 3301Cancelled Jun 29, 1970 · Broderick William C N8672YPiper PA-30 · S/N 30-1815Cancelled Jun 29, 1970 · Dale Mcmullen N49082Ryan Aeronautical ST3KR · S/N 1544Cancelled Dec 4, 1967 · La Tourette Donald P N2422APiper PA-18-135 · S/N 18-1928Cancelled Mar 11, 1966 · Wing James B N5046NBeech C18S · S/N 8175Cancelled Oct 22, 1965 · Broderick William C N56427Boeing A75N1 · S/N 75-4745Cancelled May 25, 1965 · Darrell L Olson N6761PPiper PA-24-250 · S/N 24-1891Cancelled Feb 16, 1964 · Exported to Australia · Built 1960 · Ward Lane N7271PPiper PA-24-180 · S/N 24-2447Cancelled Jun 20, 1962 · Exported to Australia · Ward Lane R N5799HPiper PA-16 · S/N 16-415Cancelled Sep 26, 1960 · Built 1949 · Rogers Wendal A N68439Cessna T-50 · S/N 2990Cancelled Feb 17, 1956 · Nelson M L N56089Boeing A75L3 · S/N 75-281Cancelled Dec 2, 1955 · Gentleman S P N57092Fairchild M-62A · S/N T42-3104Cancelled Oct 24, 1955 · Morabe Carl C N3376NPiper J3C-65 · S/N 22576Cancelled Oct 6, 1955 · Built 1946 · Dunlop William G Etal N3610KPiper J3C-65 · S/N 22298Cancelled Oct 4, 1955 · Garber Merle And W Angle N88296Piper J3C-65 · S/N 15914Cancelled May 19, 1953 · Connley Rex N2058HEngineering & Research 415-C · S/N 2681Cancelled Jan 2, 1952 · Built 1946 · Fisher Marion N48952Aeronca 0-58B · S/N 058B-4642Cancelled Dec 26, 1950 · Atwood Lawrence E N81155Funk B85C · S/N 285Cancelled May 31, 1949 · Lagier Gilbert N88167Piper J3C-65 · S/N 15784Cancelled Apr 12, 1949 · Delphia John N10626Hawke Crop Dusting HAWKE DUSTER · S/N 2Cancelled Apr 6, 1948 · Built 1931 · Hawke E R N9119New Standard D-25 · S/N 122Cancelled Feb 17, 1948 · Boyd George T Jr/Streif R J N8674Curtiss Wright FLEDGLING J-1 · S/N B-15Cancelled Oct 16, 1947 · Delphia John & William G Dunlop N430Lincoln LINCOLN PAGE 3 · S/N 210Cancelled Dec 27, 1941 · Olinger Kenneth William N17896Jones D-27 SPECIAL · S/N 158-JCancelled Jun 5, 1941 · Boyd Jr George T & R J Streif N10609Hawke Crop Dusting HAWKE DUSTER · S/N 1Cancelled May 15, 1941 · Built 1931 · Hawke E R N509NCurtiss Wright ROBIN 4C-1A · S/N 702Cancelled May 1, 1941 · Porter William H N17012Porterfield 35W · S/N 302Cancelled Jul 27, 1939 · Porter William H N3803Swallow SWALLOW · S/N 1077Cancelled Jan 1, 1939 · Built 1929 · Olinger Kenneth William N10627Hawke Crop Dusting HAWKE DUSTER · S/N 3Cancelled Jul 22, 1937 · Built 1931 · Hawke Crop Dusting Co Hawke E R N348VAlexander PRIMARY GLIDER · S/N 6Cancelled Jun 25, 1936 · Ard Ray & Carl Harlacher N9017Travel Air 4000 · S/N 818Cancelled Oct 26, 1933 · Deaton Roy D

Back to Modesto, CA