Titusville, FL
Cancelled registrations · 175
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 = 'FL' AND d.registrant_city = 'TITUSVILLE' 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 = 'FL' AND d.registrant_city = 'TITUSVILLE' 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.
N40PFCostruzioni Aeronautiche Tecna P2010 TDI · S/N 163/USN2UZBeech V35B · S/N D-9980N21409Schweizer 269C-1 · S/N 0365N108LKNord 1002 · S/N 246N8127UCessna 150M · S/N 15077894N164ABOriginal Consolidated Current AIR COMMAND L-13A · S/N 46-164N3315CBeech E35 · S/N D-3981N817ASCessna T337H · S/N 33701849N29799Hiller UH-12B · S/N 601N29253Culver LCA · S/N 121N731ASCessna T337H · S/N 33701911N1713SSchweizer 269C-1 · S/N 0214N48142Fairchild M-62A · S/N T437039N152SEAerotique PARASOL · S/N ARO4N1830DSchweizer 269C-1 · S/N 0262N1877BLuscombe 8F · S/N 6304N1907Pruett John D JP3 · S/N JP-3N51736Fairchild M-62A · S/N T423563N818ASCessna 337G · S/N 33701674N8TQBellanca 14-19-3 · S/N 4192N913BSViking Air DHC-6-400 · S/N 913N2074BSchweizer 269C-1 · S/N 0338N89JWWill Jeffrey FOKKER DVIII · S/N 08N401JFViking Air DHC-6-400 · S/N 903N7054MCessna 175 · S/N 55354N138MMViking Air DHC-6-400 · S/N 888N2064QSchweizer 269C-1 · S/N 0094N46954Cessna 152 · S/N 15283150N4956SStits Playboy SA-3A · S/N P-636N1689EAeronca 7AC · S/N 7AC-5254N72268Cessna 337G · S/N 33701550N127JSStewart Mw/Stewart JD SONERAI 2L · S/N 064N37JGGarrison James W P5151 · S/N 0001N2787NCessna 140 · S/N 13048N48122Cessna 152 · S/N 15283285N48570Cessna 152 · S/N 15280918N419Cessna T337G · S/N P3370254N961ACCessna 172R · S/N 17280736N11TLLempicke STOKES AX-6 · S/N 264-HN4485LLivengood Donald R JR LONG-EZ · S/N 1102N896JFViking Air DHC-6-400 · S/N 896N4543XPiper PA-34-200T · S/N 34-7670067N3246PPiper PA-23-160 · S/N 23-1191N3492PPiper PA-23-160 · S/N 23-1468N441WAPiper PA-23-160 · S/N 23-1944N2365XAllen Larry V GOLDWING · S/N 20604N116PHHouston Peter SOLARIS · S/N PH3N821CDDesmond Christopher ZENITH CH701 · S/N 7-4094N499WCessna 401 · S/N 401-0273N3293LCessna 172H · S/N 17256193
Back to Titusville, FL