Minden, NV
Cancelled registrations · 80
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 = 'NV' AND d.registrant_city = 'MINDEN' 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 = 'NV' AND d.registrant_city = 'MINDEN' 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.
N231VMMooney M20K · S/N 25-0426N777HPBalony Kubicek Spol Sro BB20XR · S/N 1458N959PADehavilland DHC-3 · S/N 159N926JVAerospatiale SA315B ALOUETTE III · S/N 2268N5770FAerospatiale SA315B · S/N 2593N371SHEurocopter AS 350 B3 · S/N 3830N113TMBeech B36TC · S/N EA-386N556MABritish Aerospace BAE 146 SERIES 200 · S/N E2106N446MABritish Aerospace BAE 146 SERIES 200 · S/N E2111N1247MCessna T337E · S/N 33701247N880TBeech 95-B55 (T42A) · S/N TC-788N428BGBurkhart Grob G 103 TWIN II · S/N 3740N3875RBurkhart Grob Flugzeugbau G109 · S/N 6133N8702SCessna 150F · S/N 15062002N783SDBell 206 · S/N 40097N418APAMS Flight D O O CARAT A · S/N CA012N56FDDavis Frank R XENOS MOTORGLIDER · S/N XNS-019N790GBurkhart Grob G-103A TWIN II ACRO · S/N 33987-K-220N64WBThruster Aircraft P/L T300 · S/N 088-353N6713DBeech C24R · S/N MC-711N995HBeech E18S · S/N BA-375N810CFHopkins Val II · S/N 291N73244Bell 47G-3B · S/N 2776N4692ALockheed SP-2H · S/N 148357N426MSchempp-Hirth NIMBUS 4 · S/N 8N21849Piper J4A · S/N 4-403N54MHPiper PA-28-235 · S/N 28-11158N88CSBeech 95-B55 (T42A) · S/N TC-723N1533ZBeech 95-A55 · S/N TC-326N70731Let BLANIK L-13 · S/N 026934N103BKBurkhart Grob G-103A TWIN II ACRO · S/N 33953-K-186N9141FHughes 369HS · S/N 430468SN482BBeech A35 · S/N D-1501N4964CCessna T210N · S/N 21063692N9518XCessna 210A · S/N 21057818N3028CBeech J35 · S/N D-5693N2060CBeech 95 · S/N TD-253N53011Dehavilland BEAVER DHC-2 MK.3 · S/N 1646N758RMCessna R172K · S/N R1723300N58928Cessna 182P · S/N 18262399N925GBurkhart Grob Flugzeugbau G102 CLUB ASTIR IIIB · S/N 5587 CBN49443Burkhart Grob G 103 TWIN II · S/N 3848-K-94N804WPDehavilland CHIPMUNK T.10 MK-22 · S/N C1-0698N76AARolladen Schneider LS-6C · S/N 6333N337RHBell 47G-3B-1 · S/N 6583N95730Universal TAYLORCRAFT BC12-D · S/N 8030N4599YPiper PA-25-235 · S/N 25-4291N4227CCessna 414 · S/N 414-0527N16LBSchempp-Hirth NIMBUS 4 · S/N 2N41BMSchempp-Hirth VENTUS CM · S/N 25
Back to Minden, NV