Anaheim, CA
Cancelled registrations · 151
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 = 'ANAHEIM' 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 = 'ANAHEIM' 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.
N6799FCessna 150F · S/N 15063399N6915ECessna 175A · S/N 56415N4112AFairchild C-123K · S/N 54-661N99412North American T-28A · S/N 122N9860ANorth American T-28D · S/N 51-7669N99422Douglas B-26B · S/N 423N8064ERobinson Helicopter R22 BETA · S/N 1264N34FLDouglas DC3C · S/N 4790N11MWBuzzard B-8M · S/N 61524N74944Piper PA-31-350 · S/N 31-7305089N99393North American T-28A · S/N 389N99425Douglas B-26B · S/N 162N9012NJunkers JU-52 · S/N T.2B-142N8SWPiper PA-34-200T · S/N 34-7570145N7681CNorth American TB-25N · S/N 44-86701N77DJHughes 369HS · S/N 0683N680JDAero Commander 680W · S/N 1792-22N54610Douglas DC3 · S/N 43-161-141N54611Douglas DC3 · S/N 43-49206N3039Arnoldt BENSEN B8M · S/N CGA1N5272JCessna 404 · S/N 404-0024N5233SPiper PA-32-300 · S/N 32-40929N47780Boeing B-17G · S/N 44-83663N4064WPiper PA-32-300 · S/N 32-40097N68106Chipman CHALLENGE · S/N CC-001N33639Douglas DC-3A-S1C3G · S/N 4085N3524BBeech E35 · S/N D-3741N2298PPiper PA-23 · S/N 23-910N2867HEngineering & Research ERCOUPE 415-D · S/N 3492N5706LAmerican AA-1 · S/N AA1-0106N5830PPiper PA-24-250 · S/N 24-911N1461Jongblood Glider 1 · S/N 1N4415BCessna 170B · S/N 26759N1116SSchweizer SGS 1-26E · S/N 506N411RGuilford BD-5 MODEL A · S/N 403N5469YDouglas AD-4W · S/N 127922N135FFLockheed C-130A · S/N 56-540N3644CCessna R182 · S/N R18200291N132ATDouglas A4D-2N · S/N 12374N2242Pohl B-8M · S/N 1N54608Douglas DC3 · S/N 42-92136N41715Culver LFA · S/N 432N3446GNorth American B-25C · S/N 4431466AN105VBeech C-50 · S/N CH-131N222SFCessna P210N · S/N P21000637N241DRCessna 421B · S/N 421B0912N7113XCessna 150A · S/N 15059213N2715ZSchweizer SGS 1-26B · S/N 250N24SGGuilford BD-4 · S/N 24N62554Lotter Robert P L-2 · S/N 001
Back to Anaheim, CA