Zephyrhills, FL
Cancelled registrations · 69
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 = 'ZEPHYRHILLS' 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 = 'ZEPHYRHILLS' 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.
N7620WPiper PA-28-180 · S/N 28-1584N5158UHeinz Rich KR-2 · S/N 666N401KGMichael Bullock DOMINATOR SNGL SEAT · S/N 0001N935CSS.A.Centrair PEGASE 101 · S/N 101-002N534PREvolution REVO · S/N 000585N1984WBeech B19 · S/N MB-666N4785DCessna 182A · S/N 34885N5YYCessna 177RG · S/N 177RG0758N454BALet L-23 SUPER BLANIK · S/N 039019N162ARAbid Farooqui AR-1 · S/N 0025N33311Osborne George A O S J-1 · S/N J-001N806PMBest OFF SKYRANGER · S/N SKR0201163-2000N304APApollo North America TUNDRA · S/N KLM0004N229PFortuna Dave SONEX-EXPERIMENTAL · S/N 018N221DACessna 500 · S/N 500-0201N82EVEvolution Trikes REVO · S/N 1003N83EVEvolution Trikes REVO · S/N 1004N314FFFava Albert BD4 · S/N 001N48045Let BLANIK L-13 · S/N 026023N4413Let L13 AC BLANIK · S/N 175108N935AHMiles Richard J HAWK · S/N 092035N65807CGS HAWK ARROW · S/N H-CGS-480-RN2890XCessna 177 · S/N 17700290N24092Interplane SKYBOY · S/N 062/2002N262MXMXR Technologies MX2 · S/N 001N250EVEvolution REVO · S/N 000607N2455GCessna 182B · S/N 51755N8056Douglas DC3C · S/N 25735N254EVEvolution REVO · S/N 000610N1339XIca Brasov IS-29D2 · S/N 92N23EVEvolution REVO · S/N 000603N782RFFlorey Michael R V-MAX · S/N 782N42MFFava Albert COZY · S/N 355N37SSSayer Samuel W KR 2 · S/N 7043N203BDInterplane SKYBOY · S/N 012/2001N7050FMegill Stephen J CHALLENGER II · S/N CH2 0193-0941N6216YPiper PA-23-250 · S/N 27-3443N111STDouglas DC3C 1830-94 · S/N 4661N1UQTunderman-Venne Q-2 · S/N 2372N9921PKerfoot John R OSPREY II · S/N 5N4412CFairchild Hiller FH-1100 · S/N 187N72523Cessna 140 · S/N 9693N80EVEvolution REVO · S/N 000590N55EVEvolution REVO · S/N 000587N687ABEvolution REVO · S/N 1012N28342Douglas DC3-G202A · S/N 3279N128ABEvolution REVO · S/N 1016N41PMMuetzel Michael Paul AVID FLYER · S/N 571N29LFPlonk George J III TYTE WAD · S/N 001N78EVEvolution Trikes REVO · S/N 000561
Back to Zephyrhills, FL