Hemet, CA
Cancelled registrations · 110
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 = 'HEMET' 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 = 'HEMET' 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.
N30JRRehler J CUSTOM KB2 · S/N 1N1385BNorth American Medore T-6G · S/N 52-8199-1N37474North American-Medore SNJ-5 · S/N 88-13037N601BJJonker Bill W ZNH SPR ZODC 601 HDS · S/N 6-3075N74635Boeing PT-17 · S/N 75-7069N102FCBurkhart Grob Flugzeugbau G102 CLUB ASTIR IIIB · S/N 5621 CBN9340XCessna 182E · S/N 18253740N992SLMcdonnell Douglas Helicopter 369E · S/N 510EN1272QCessna 150L · S/N 15072572N1163SSchweizer SGS 1-34 · S/N 63N9626ZCallair A-9 · S/N 1029N17904Schweizer SGS 2-33A · S/N 284N72LCase SPECIAL · S/N W1001N4128BBellanca 17-31A · S/N 75-32-148N807WZRaven S55A · S/N S55A480N2546LPiper PA-38-112 · S/N 3879A0759N100HAHirt Mark Robert TRIO · S/N 002N996SDBell OH-58C · S/N 6916166N997SDBell OH-58C · S/N 7221444N8094SPiper PA-28-236 · S/N 287911326N444RTRaven S55A · S/N S55A-248N13745Fairchild C-119C · S/N 48322N32CRRaymond Charles B KR-2 · S/N 7945N583TBeech A36 · S/N E1020N9652RBeech B95 · S/N TD349N13746Fairchild C-119C · S/N 48352N13744Fairchild C-119C · S/N 49199N52542Heale Ross WIZARD T-38BR503 · S/N 66017N13742Fairchild C-119C · S/N 49-194N4093KLampman/Purves SURVEYOR · S/N 11N6458CConsolidated Vultee PBY-6A · S/N 46644N8256RBellanca 17-31A · S/N 32-69N7267SCessna 150H · S/N 15067967N77359Cessna 120 · S/N 11800N3775UCessna 182S · S/N 18255175N9860CGrumman TBM-3E · S/N 86118N7229CGrumman TBM-3E · S/N 86195N6825CGrumman TBM-3E · S/N 85883N7246CGrumman TBM-3E · S/N 91724N3356GGrumman TBM-3E · S/N 85844N6459CConsolidated Vultee PBY-6A · S/N 46653N9082ZGrumman TBM-3E · S/N 53727N3620GGyro-Copter B7M · S/N 2N44835Naval Aircraft Factory N3N-3 · S/N 2818N56787Boeing A75N1 · S/N 75-804N59792Boeing A75N1 · S/N 75-2386N4078KVail V-3 · S/N 1001N9679CGrumman TBM-3E · S/N 69293N44934Naval Aircraft Factory N3N-3 · S/N 2848N45062Naval Aircraft Factory N3N-3 · S/N 2727
Back to Hemet, CA