Skip to content

Cancelled registrations · 47

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 = 'KS' AND d.registrant_city = 'WINFIELD' 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 = 'KS' AND d.registrant_city = 'WINFIELD'
  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 = 'KS' AND d.registrant_city = 'WINFIELD'
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.

N933HPCirrus Design SF50 · S/N 0071Cancelled Oct 27, 2022 · Exported to Netherlands · Built 2018 · R & B Aviation LLC N3123DPowrachute PC 2000 · S/N A274POWCancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 2002 · Beeman Gary A N1970EAeronca 7AC · S/N 7AC-5537Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1946 · Swan Christopher L N1689BTemco Luscombe 11A · S/N 11-195Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1949 · Koller Derek G N5404SCessna 337A · S/N 337-0504Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1966 · Waymire Charles R N62772Boeing A75N1(PT17) · S/N 75645Cancelled Aug 5, 2013 · Revoked, canceled · Built 1940 · Winfield Air Svc N89142Cessna 152 · S/N 15282646Cancelled Nov 15, 2012 · Sale reported, pending cancellation · Built 1978 N8646LRaven Industries RX6 · S/N RX6151Cancelled Jan 31, 1995 · Triennial form not returned · Flottman Rex L N47797Cessna 152 · S/N 15283251Cancelled Feb 12, 1980 · Exported to Gabon · Built 1979 · Cessna Aircraft Company N758KNCessna R172K · S/N R1723158Cancelled Feb 12, 1980 · Exported to Pakistan · Cessna Aircraft Co N7349LCessna A152 · S/N A1520793Cancelled Feb 8, 1980 · Exported to Venezuela · Cessna Aircraft Co N6200DCessna 172N · S/N 17272630Cancelled Aug 3, 1979 · Exported to Canada · Cessna Aircraft Co N7387LCessna A152 · S/N A1520806Cancelled Oct 20, 1978 · Exported to South Africa · Cessna Acft Co N11423Cessna 150L · S/N 15075409Cancelled Mar 31, 1974 · Exported to Guatemala · Cessna Aircraft Co N11404Cessna 150L · S/N 15075393Cancelled Dec 12, 1973 · Exported to New Zealand · Cessna Aircraft Company N9924GCessna A150L · S/N A1500469Cancelled Dec 12, 1973 · Exported to New Zealand · Cessna Aircraft Co N11232Cessna 150L · S/N 15075267Cancelled Nov 14, 1973 · Exported to South Africa · Cessna Aircraft Company N11385Cessna 150L · S/N 15075374Cancelled Nov 14, 1973 · Exported to Australia · Cessna Aircraft Co N9910GCessna A150L · S/N A1500461Cancelled Nov 14, 1973 · Exported to Australia · Cessna Aircraft Co N11194Cessna 150L · S/N 5075248Cancelled Oct 23, 1973 · Exported to Australia · Cessna Aircraft Co N7756QCessna 310Q · S/N 310Q0256Cancelled Oct 3, 1973 · Gordon & Piatt Inc N10446Cessna 150L · S/N 15074861Cancelled Sep 6, 1973 · Exported to Australia · Cessna Aircraft Company N10458Cessna 150L · S/N 15074867Cancelled Sep 6, 1973 · Exported to South Africa · Cessna Aircraft Company N10475Cessna 150L · S/N 15074875Cancelled Sep 6, 1973 · Exported to Australia · Cessna Aircraft Company N10480Cessna 150L · S/N 15074879Cancelled Sep 6, 1973 · Exported to Australia · Cessna Aircraft Company N10485Cessna 150L · S/N 15074883Cancelled Sep 6, 1973 · Exported to Australia · Cessna Aircraft Company N10664Cessna 150L · S/N 15074958Cancelled Sep 6, 1973 · Exported to Bolivia · Cessna Aircraft Co/Commercial Aircraft Division N4686Daniels GYROCOPTER D-3 · S/N 19693Cancelled Oct 15, 1971 · Daniels Chester L N3815KGlobe GC-1B · S/N 3504Cancelled Jan 18, 1971 · Daniels Chester Lee N3360CBeech F35 · S/N D-4026Cancelled Feb 10, 1966 · Joe Collins Buick N37154Fairchild 24W-41A · S/N W41A-205Cancelled Aug 15, 1951 · Built 1941 · Daniels Chester L N3155KFairchild F-47 · S/N C-103Cancelled Jun 27, 1951 · Fairchild Personal Planes Div N77669Fairchild 24R-46 · S/N R46369Cancelled May 2, 1951 · Exported to Canada · Fairchild N77511Piper J3C-65 · S/N 22001Cancelled Feb 1, 1951 · Jones Warren F N77646Fairchild 24W-46 · S/N W46346Cancelled Oct 3, 1949 · Exported to Venezuela · Fairchild N77616Fairchild 24R-46 · S/N R46284Cancelled Feb 17, 1949 · Fairchild N77617Fairchild 24R-46 · S/N R46297Cancelled Feb 17, 1949 · Fairchild N77620Fairchild 24W-46 · S/N W46320Cancelled Feb 17, 1949 · Fairchild Personal Plane Div N77629Fairchild 24R-46 · S/N R46385Cancelled Sep 21, 1948 · Exported to Mexico · Fairchild Personal Planes Division N77676Fairchild 24R-46A · S/N R46317Cancelled Sep 20, 1948 · Exported to Mexico · Fairchild N77699Fairchild 24R-46 · S/N R-46340Cancelled Jul 16, 1948 · Exported to Mexico · Fairchild N77675Fairchild 24R-46 · S/N R46-375Cancelled May 6, 1948 · Exported to Mexico · Fairchild N77679Fairchild 24R-46 · S/N R46-379Cancelled May 6, 1948 · Exported to Mexico · Fairchild N77685Fairchild 24R-46 · S/N R46-329Cancelled May 6, 1948 · Exported to Mexico · Fairchild N81252Fairchild 24W-46 · S/N W46300Cancelled Mar 12, 1948 · Exported to Canada · Fairchild Personal Planes Division N77633Fairchild 24R-46 · S/N R46354Cancelled Oct 21, 1947 · Exported to Mexico · Fairchild Personal Planes N7884Lincoln LINCOLN PAGE 3 · S/N 255Cancelled Sep 7, 1935 · Savoy Neal

Back to Winfield, KS