Compton, CA
Cancelled registrations · 111
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 = 'COMPTON' 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 = 'COMPTON' 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.
N61011Cessna 150J · S/N 15070732N91315Douglas C-47B · S/N 33542N43514Taylorcraft BC12-D · S/N 7173N80190Beech D18S · S/N A-291N7160XCessna 150A · S/N 15059260N2433UCessna 172D · S/N 17250033N91637North American NAVION · S/N NAV4158N3326BPiper PA-22-135 · S/N 22-2141N67224Cessna AT 17B · S/N 3050N3554UCessna 182F · S/N 18254954N2353QBeech 23 · S/N M-421N89805Cessna 120 · S/N 8854N4642ZPiper PA-22 · S/N 22-8161N50220Timm N2T-1 · S/N 296N9829CConsolidated Vultee P4Y-2 · S/N 59932N4303VCessna 195 · S/N 7202N5756WPiper PA-28-150 · S/N 28-1517N2742MPiper PA-12 · S/N 12-1145N71140Luscombe 8A · S/N 2567N77100Cessna 120 · S/N 11558N65177Stinson VULTEE V-77 · S/N 77-183N52209Consolidated Vultee BT-13A · S/N 3563N66664Consolidated Vultee BT-13A · S/N 6121N86917Bellanca 14-13-2 · S/N 1279N1096KLuscombe 8A · S/N 3823N56007Ryan Aeronautical PT-22 · S/N 2090N30018Consolidated Vultee BT-13 · S/N 7397N48908Taylorcraft L-2M · S/N 5419N68148Cessna T-50 · S/N 6356N34555Aeronca 65-CA · S/N CA-15731N6818MStinson 108-3 · S/N 108-4818N36108Taylorcraft BF-65 · S/N 3075N92758Piper PA-12 · S/N 12-200N3710KGlobe GC-1B · S/N 1403N54748Fairchild M-62A · S/N T43-5061N948DStinson 108-2 · S/N 108-2948N14683Waco CUC · S/N 4282N8308KStinson 108-1 · S/N 108-1308N1019Stinson SM-1 · S/N M-205-AN2775Waco 9 · S/N 253N14264Kinner SPORTSTER K · S/N 46N14471Porterfield 35-70 · S/N 131N218YKinner Airplane & Motor KINNER 100-K · S/N 22N218YKinner SPORTSTER K · S/N 22N29308Waco UPF-7 · S/N 5335N8435KStinson 108-1 · S/N 108-1435N93577Ercoupe 415-C · S/N 900N14460Cessna C-34 · S/N 300N25594Porterfield LP-65 · S/N 694N728VFleet 2 · S/N 341
Back to Compton, CA