Oshkosh, WI
Cancelled registrations · 340
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 = 'OSHKOSH' 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 = 'OSHKOSH' 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.
N856RBDouglas DC3 · S/N 4654N98904Cessna 310R · S/N 310R1240N16158Cessna 150L · S/N 15073510N4142DPiper PA-28-181 · S/N 2843358N53PWExperimental Aircraft Assn STOL CH 750 · S/N 75-8742N799TSBeech 99 · S/N U-57N9267HPiper PA-28-181 · S/N 2843027N47436Piper PA-28-181 · S/N 28-7890073N3378QCessna 402B · S/N 402B0334N337BFReims CESSNA FTB337G · S/N 0061N8431SCessna 182H · S/N 18256531N16SXDarrell J Lowrance SX-300 · S/N 64N399TSBeech 99 · S/N U-32N7482JDJI PHANTOM 2 · S/N PH45221102N6450BCessna 152 · S/N 15283935N651KHDJI INSPIRE 1 · S/N W13DCB2502509N17124Stinson SR-8E · S/N 9806N136BJBeech A36 · S/N E-1077N2385LBeech 23 · S/N M-226N2616TCosmos PHASE II · S/N JDOM04N2ZROsmundson Donald J W A R A6M5 ZERO · S/N 2N572JJay D Puestohl BUTTERCUP · S/N 001N95MWWilliams Munsil BUDDY BABY LAKES · S/N 8921A1024BBN90023Cessna 140 · S/N 9081N720RSGerlach Mark CHALLENGER II · S/N CH2-0197-1555N90173Gerlach Mark D SUPER SKYRAIDER · S/N SSR-03N270JWJames S Wood REGNELLAHC · S/N 007N331KBPiper PA-31T1 · S/N 31T-7804009N4637KCessna 182P · S/N 18263639N12937Hanson PIETENPOL AIR CAMPER · S/N 1N5241ACessna 310 · S/N 35441N404PECirrus Design SR22 · S/N 2429N2253UBrantly B-2B · S/N 412N59YRoloff RLU-1 · S/N 5537N22CZCo-Z Development CO-Z · S/N 1N51973Hunting PEMBROKE MK 51 · S/N K66B-4001N17484Aeronca LC · S/N 2060N5559Beech F33C · S/N CJ-110N970RVHammond Richard D VANS AIRCRAFT INCRV9 · S/N 91703N97906Stinson 108 · S/N 108906N1085UCessna 172M · S/N 17266834N275NLincoln PT-K · S/N 602N21292Taylorcraft BC · S/N 1086N28961Ercoupe 415-C · S/N 57N384LNeibauer Lance A LANCER · S/N LN1984N333BSCessna 310R · S/N 310R0865N19723Aeronca K · S/N K-244N13191Fairchild 24 C8 · S/N 2009N208GDOshkosh Acft Builders Club SONEX · S/N 450N35PPWisman Emery C PRESCOTT PUSHER · S/N 35
Back to Oshkosh, WI