Long Beach, CA
Cancelled registrations · 1,037
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 = 'CA' AND d.registrant_city = 'LONG BEACH' 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 = 'CA' AND d.registrant_city = 'LONG BEACH' 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.
N8475TCessna 182C · S/N 52375N4464PBurkhart Grob Flugzeugbau G103 TWIN ASTIR · S/N 3823-K-82N938JADJI AIR 2S · S/N 3YTBJ3Q00301R9N221ZEJetzero PATHFINDER · S/N AV-01N747YKeystone Helicopter S-76C · S/N 760747N90DBCessna 510 · S/N 510-0193N3307ECessna 172N · S/N 17271499N27761Stinson 10 · S/N 7714N471VAPiper PA-31-350 · S/N 31-8352015N6712PBeech 76 · S/N ME-315N5283XChampion 7KCAB · S/N 217N5221ACessna T210N · S/N 21063315N536LSRolladen-Schneider LS-6 · S/N 6329N442BCBeech S35 · S/N D-7358N98WRCessna T210M · S/N 21061770N146TPCostruzioni Aeronautiche Tecna P2002 SIERRA · S/N 266N4151QBeech A36 · S/N E-2679N67589Douglas DC3 · S/N 19656N862MACessna 208B · S/N 208B1138N48962Cessna 152 · S/N 15281075N611DDBeech C90 · S/N LJ-806N6752RCessna T210F · S/N T210-0152N7121WBalloon Works FIREFLY 8B · S/N F8B-104N23749Stinson HW75 · S/N 7205N7850XCessna 172B · S/N 17248350N66824Fairchild M-62A · S/N 244HON3533XMooney M20F · S/N 670070N2457LCessna 172H · S/N 17255657N234AHEurocopter AS 350 BA · S/N 2489N45843Luscombe 8A · S/N 2370N911XSMaher William E EUROPA XS MTR GLIDER · S/N 164N801HWHeli Watch BIGDRONE1 · S/N HW001N101HWDJI Innovations PHANTOM P330 · S/N P330CB-02F0122054N301HWDJI INSPIRE 1 · S/N HW00301N501HWDJI Innovations S900 · S/N 370010570N761WKCessna T210M · S/N 21062575N347HArrow Aircraft & Motors ARROW SPORT · S/N 401N144RBBerkely SCORPION-2 · S/N RB-1N48641Aeronca 0-58B · S/N O58B6422N669JTDJI PHANTOM 2 · S/N PT645431440N739XECessna 172N · S/N 17270882N3960VCessna 170 · S/N 18279N5508ECessna 172N · S/N 17271880N627VWDJI INSPIRE 1 · S/N W13DCC23030164N8894FHughes 269A · S/N 830270N484JDCessna 182S · S/N 18280516N1318WMooney M20E · S/N 206N138JCDJI S1000+ · S/N 03P0011749N139JCDJI S1000+ · S/N 03P0011774N140JCDJI S1000+ · S/N 03P0011775
Back to Long Beach, CA