Davie, FL
Cancelled registrations · 121
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 = 'DAVIE' 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 = 'DAVIE' 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.
N4427XPiper PA-28R-200 · S/N 28R-7635039N1542Raytheon B200 · S/N BB-1916N88AGPiper PA-34-200 · S/N 34-7450093N890GTHawker Beechcraft C90GTI · S/N LJ-1879N3400HHawker Beechcraft C90GTI · S/N LJ1890N25493Cessna 152 · S/N 15280692N550TTCessna 550 · S/N 550-1130N953BCessna 152 · S/N 15285874N49NMPiper PA-31T · S/N 31T-7520006N711AHPiper PA-31T · S/N 31T-8120016N208FZCessna 208B · S/N 208B5003N60041Hawker Beechcraft B300 · S/N FL-631N631PFAero Commander 100 · S/N 189N313BBPiper PA-42-720 · S/N 42-5501016N515BCBeech E-90 · S/N LW-121N1933SBeechcraft B200GT · S/N BY-227N757MBritish Aerospace BAE 125 SERIES 800A · S/N NA0402N829DAPiper PA-31-350 · S/N 318152080N941CYHawker Beechcraft C90GTI · S/N LJ-1941N500YVPiper PA46-500TP · S/N 4697598N811AWPipistrel Doo Ajdovscina VIRUS SW · S/N 823 SWN 100N705NMDJI PHANTOM 2 VISION + · S/N PH645442125N654NPiper PA-31-310 · S/N 31-683N685MSDJI INSPIRE 1 PRO · S/N W21ACI16010099N8199XCessna 172B · S/N 17248699N629ALPiper PA46-500TP · S/N 4697629N607RSDJI S1000+ · S/N TRM-1188N780HSCessna 525 · S/N 525-0327N4459YDowell John C CAVALIER SA102.5 · S/N 001N361JSRaytheon B200 · S/N BB-1841N749DBBoeing 757-200 SERIES · S/N 24749N117SSchoonover John D KIT FOX IV 1200 · S/N 1774N4702XCessna 150G · S/N 15064752N46LLLopez Francisco JR COZY · S/N 440N406WADouglas C54G-DC · S/N 35944N44547Bianco Robert L BIANCO DRIFTER 912 · S/N RB001N235GLAirbus Industrie A300 B4-203 · S/N 235N3008GCameron Balloons US C-80 · S/N 6031N741FGCirrus Design SR22 · S/N 4198N736LSCessna R172K · S/N R1722617N5853Sorenson Mark HARMINING HIGHFLYER · S/N 5850N2066SCessna T210L · S/N 21061033N1984Boeing 727-23 · S/N 18440N54717Raven S55A · S/N S55A-204N247LMPiper PA-31T1 · S/N 31T-8104043N1972Boeing 727-23 · S/N 18428N761EMCessna T210M · S/N 21062198N617SRCirrus Design SR22 · S/N 2551N25LVLavia Argentina PA-25-260 · S/N LA-260-12056N3172GNorth American T-6G · S/N 49-3172-A
Back to Davie, FL