Neenah, WI
Cancelled registrations · 66
Query with SQL
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 = 'WI' AND d.registrant_city = 'NEENAH' 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 = 'WI' AND d.registrant_city = 'NEENAH' 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.
N9429DPiper PA-22-160 · S/N 22-6403N96702Taylorcraft BC12-D · S/N 9002N10DSBeech 95-B55 (T42A) · S/N TC-943N9947TCessna 182D · S/N 18253047N604UBDJI PHANTOM 3 PROFESSION · S/N CE142048495579N61128Cessna 150J · S/N 15070821N8158Bensen B-8M · S/N M1N56PKKeesler Patrick E W8 TAILWIND · S/N 1953N61791Powrachute SKY RASCAL · S/N SR057N173JKPowrachute PC 2000 · S/N A240POWN9SUSielaff Jonah S-1 MOSKIT · S/N 001N910Bongert-Wuest-Wojahon CASSUTT 3M · S/N 216N4329JCanadian Car & Foundry HARVARD MK IV · S/N CCF-4-144N7462Haufe HAWK-MODEL 4 · S/N 102N6401KCessna 172P · S/N 17274193N431CUniversal Stinson 108-2 · S/N 108-3431N2841UCessna 172D · S/N 17250441N2313APiper PA-38-112 · S/N 38-78A0634N572PAPiper PA-28-140 · S/N 28-7525327N89919Cessna 152 · S/N 15282914N4956Grunska Norman KITFOX IV · S/N 1428N29WWCessna 210N · S/N 21063308N51771Boeing A75N1(PT17) · S/N 752186N9629HCessna 172M · S/N 172-66277.N2161PPiper PA-23 · S/N 23-763N418FBeech 35 · S/N D-1285N19257Cessna 150 · S/N 15074280N8987UCessna 150M · S/N 15078037N704XZCessna 150M · S/N 15078968N1UWDehavilland DHC-3 · S/N 276N6715JPiper PA-28-140 · S/N 28-24417N64357Cessna 172M · S/N 17265189N3947WPiper PA-32-260 · S/N 32-896N2403CCessna 180 · S/N 30703N6454UMooney M20C · S/N 2208N4418UCessna 150 · S/N 15060418N66214Cessna 150M · S/N 15075925N6354FCessna 337A · S/N 337-0354N99880Forney 415-D · S/N 2503N8372RPiper PA-28-140 · S/N 28-22249N600KCPiper PA-23-250 (6PCLM) · S/N 27-7405295N8391LCessna 172I · S/N 17256591N79409Cessna 172 · S/N 17258060N79061Cessna 172K · S/N 17257852N6711GCessna 150L · S/N 15072211N1051ZHawk 3 · S/N 101N93916Ercoupe 415-C · S/N 1239N4319UCessna 150D · S/N 15060319N1865PPiper PA-18-150 · S/N 18-4134N2286HEngineering & Research ERCOUPE 415-C · S/N 2911
Back to Neenah, WI