Cancelled registrations · 27

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 = 'DC' AND d.registrant_city = 'WASHINGTON DC' 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 = 'DC' AND d.registrant_city = 'WASHINGTON DC'
  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 = 'DC' AND d.registrant_city = 'WASHINGTON DC'
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.

N973JSDehavilland TIGER MOTH DH 82A · S/N EM973Cancelled Jul 10, 2013 · Sale reported, canceled · Built 1943 N53UACessna 411 · S/N 411-0247Cancelled Sep 18, 2012 · Sale reported, pending cancellation · Built 1966 N26092Klein ICARUS II-B · S/N A-16Cancelled Sep 18, 2009 · Registration revoked · Built 1976 · Klein Fred R N611MFAero Commander 680FL · S/N 1772-10Cancelled Apr 5, 1983 · U S Dept Interior Bureau Of Reclamation N57272Rockwell International 500-S · S/N 3210Cancelled Oct 20, 1975 · Exported to Iran · Air Carrier Service Corp N70265Cessna 185E · S/N 18502085Cancelled Dec 12, 1973 · Exported to Indonesia · General Conference Corp Of Seventh Day Adventists N3ALHawker Siddeley HS125 SERIES 3B · S/N 25169Cancelled Jul 7, 1972 · Exported to United Kingdom · Built 1972 · Omni Investment Corp N2929RCessna 310G · S/N 310G-0129Cancelled Dec 7, 1970 · Lynnellen Inc N999PNavion NAVION A · S/N NAV-4-1708Cancelled Oct 29, 1967 · U S Air Force Owner Uasf Aero Club Operator N51585Curtiss Wright C-46A · S/N 30549Cancelled Jul 13, 1951 · Exported to Brazil · Air Carrier Service Corp N50160Curtiss Wright O-52 · S/N 14242Cancelled Feb 4, 1949 · Holmberg Aerial Survey Co N46Beech D17S · S/N 4812Cancelled Dec 1, 1948 · Civil Aeronautics Administrative N45100Naval Aircraft Factory N3N-3 · S/N 4457Cancelled Oct 6, 1948 · US Department Of Commerce Caa/Civil Aeronautics Ad N16143Stinson SR-8B · S/N 9711Cancelled Aug 4, 1948 · Airpark And Personal Aviation Developmen Corp N278North American SNJ-4 · S/N 9774Cancelled Jul 14, 1948 · United States Govt Civil Aero Admin N26721Piper J3L-65 · S/N 4144Cancelled Jun 28, 1948 · Defense Plant Corp N280North American SNJ-4 · S/N 10773Cancelled Mar 9, 1948 · Department Of Commerce N280Consolidated Vultee BT-13 · S/N 6893Cancelled Feb 26, 1946 · U S Government Civil Aeronautics Administration N8009Fairchildairplane Mfg 51-A · S/N 158Cancelled Nov 18, 1942 · Defense Supplies Corp N2786Grumman G-21A · S/N 1060Cancelled Aug 11, 1942 · US Government/Navy Department/Defense Supplies Cor N16094Douglas DC3 · S/N 1915Cancelled Oct 6, 1941 · Defense Supplies Corp N1001Rudolph C Hard HARD CLUSTER FREE BA · S/N 1Cancelled Sep 26, 1940 · Hard Rudolphc N66Beech B17L · S/N B17L-26Cancelled Jun 24, 1940 · Civil Aeronautics Authority N79Stinson SR-8B · S/N 9813Cancelled Jul 17, 1939 · Civil Aeronautics Authority N46Monocoupe D145 · S/N D-112Cancelled Jan 16, 1936 · Bureau Of Air Commerce N12267Douglas O-38S · S/N 1121Cancelled Nov 28, 1932 · Militia Bureau United States Army N302HDehavilland MOTH · S/N 5-ACancelled Mar 25, 1932 · Curtiss Wright Flying Service Inc

Back to Washington Dc, DC