Riverside, CA
Cancelled registrations · 287
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 = 'RIVERSIDE' 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 = 'RIVERSIDE' 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.
N7269LAmerican AA-1A · S/N AA1A-0469N8311ARobinson Helicopter R22 BETA · S/N 2442N220DKCessna 510 · S/N 510-0150N3316TCessna 177 · S/N 17700616N524SEBeech B200 · S/N BB1332N450DACessna P210N · S/N P21000381N905PJCessna 208B · S/N 208B5045N683CTDJI PHANTOM 2 · S/N PH646011197 V2.0N1918DNordquist Conrad NORDQUIST FOKKER DVI · S/N 101016N6989Lightsey Mark A CAUDRON C.460 · S/N 100N84FFielder MAVERICK MA-3 · S/N MA-3-001N261YEvans Aircraft Body Shop RV-4 · S/N R-4-261N263YTurner William H RT 14 REPLICA · S/N T-11N341BBeech H35 · S/N D-4907N449WBEvolution REVO · S/N 000614N88XDWathen Thomas W DH 88 COMET · S/N T-7N40336Cessna 172 · S/N 36720N6877Schleicher AS-K13 · S/N 13149N214Ercoupe 415-D · S/N 607N47753Aeronca 0-58B · S/N 058B-3892N3699CCessna R182 · S/N R18200314N88028Piper J3C-65 · S/N 15647N4164NCessna 140 · S/N 13635N12EDCessna 414 · S/N 414-0521N5TPCessna 172M · S/N 172-63014N68LLRhea Larry M RV6A · S/N 60481N86821Bellanca 14-13 · S/N 1182N1088PPiper PA-23 · S/N 23-97N6746UMooney M20C · S/N 2468N9076URobinson Helicopter R22 · S/N 0261N20WEPiper PA-31T1 · S/N 31T-8004025N689RPDJI PHANTOM 3 PROFESSION · S/N P76DCD21010236N738XUDJI PHANTOM 3 PROFESSION · S/N CE281111325154N94469Cessna 152 · S/N 15285683N9198TPiper PA-38-112 · S/N 38-78A0274N19084Cessna 150L · S/N 15074155N4968BBeech D-50 · S/N DH-23N637XBDJI PHANTOM 2 VISION + · S/N PH645313507 V2.0N4508ZPiper PA-22-108 · S/N 22-8010N593JNSteinke Gary H EARLY BIRD ACFT-JENN · S/N 000113N131FSDouglas DC3C-S1C3G · S/N 32920N97DBPiper PA-34-200T · S/N 34-7870457N9549DPiper PA-22 · S/N 22-6466N513LNMark W Noble WEIGHT SHIFT CONTROL · S/N MD 50 50N4003SRobinson Helicopter R22 BETA · S/N 1409N3597TS N I A S AS350D ASTAR · S/N 1126N80012Red Wings RW-50 · S/N 147N186SSheehan Michael F SPECIAL · S/N 1N5641ECessna 150 · S/N 17141N5348KRyan NAVION B · S/N NAV-4-2248B
Back to Riverside, CA