Hollywood, FL
Cancelled registrations · 262
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 = 'HOLLYWOOD' 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 = 'HOLLYWOOD' 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.
N5645WPiper PA-28-150 · S/N 28-801N608HFEurocopter AS 350 B3 · S/N 3188N6449PCessna 152 · S/N 15285015N717FFLearjet 60 · S/N 213N911SQCessna 310Q · S/N 310Q0767N326NBritish Aerospace BAE 125 SERIES 800A · S/N NA0427N6937LCessna 310K · S/N 310K0037N236BCBeech B36TC · S/N EA588N22GULearjet 60 · S/N 022N64WACessna T303 · S/N 30300044N172FLPiper PA-34-220T · S/N 3449159N462HAAntonov AN-74-200 · S/N 365.470.98.956N82ARBell 47G · S/N 1029N161MXDJI INSPIRE 1 · S/N W13DCC05020145N160MXFreefly Systems ALTA · S/N 781842N7800XCessna 172B · S/N 17248300N733VBCessna 172N · S/N 17268573N381AFDJI PHANTOM 3 PROFESSION · S/N PH645420554N739SFCessna 172N · S/N 17270763N98BYDJI PV331 · S/N PH645374895 V2.0N6158SAir & Space America 18A · S/N 18-69N4644LCessna 172G · S/N 17254639N735SFDJI PHANTOM 2 · S/N PT645189286N65DJInfinity Power Parachutes INFINITY 2002 · S/N IPP2-138N450KKGulfstream Aerospace G-IV · S/N 1225N6118SAir & Space America 18A · S/N 18-53N6143SAir & Space America 18A · S/N 18-51N302CLIsrael Aircraft Industries ARAVA 101B · S/N 46N143HRReiskin Herb REISKIN MIDG MUSTANG · S/N R-1N160AJLearjet 60 · S/N 005N6516UMooney M20C · S/N 2299N7906GCessna 172L · S/N 17259606N428SWWalton Stephen L RAF 2000 GTX · S/N H2-97-8-304N21077Robinson Helicopter R22 BETA · S/N 1113N222AQSmith AEROSTAR 601P · S/N 61P-0164-004N135FAGates Learjet 35A · S/N 067N6321Youmer YF-3 · S/N 101N6331Youmer YF-2 · S/N 102N2585JCessna 150E · S/N 15061085N28049Bellanca 17-30A · S/N 78-30888N6550FCessna 182Q · S/N 18265953N8032SCessna 150F · S/N 15061632N5332YPiper PA-23-250 · S/N 27-2409N54BFFertel Bruce C T-BIRD II · S/N TB41996N94486Douglas DC3C · S/N 19991N8466DPiper PA-18A 150 · S/N 18-6166N2100PPiper PA-23 · S/N 23-688N75607Cessna 172N · S/N 17267846N601JMCanadair CL-600-2A12 · S/N 3048N98ECessna 560 · S/N 560-0103
Back to Hollywood, FL