Panama City, FL
Cancelled registrations · 182
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 = 'PANAMA CITY' 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 = 'PANAMA CITY' 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.
N714GGRobinson Helicopter R44 II · S/N 10123N9715TPiper PA-38-112 · S/N 38-78A0168N7943YPiper PA-30 · S/N 30-1036N233JASchweizer 269C · S/N S1798N761DGDJI PHANTOM 2 VISION + · S/N PH645451952N986PBHawker Beechcraft 390 · S/N RB-290N1803RSchweizer 269C-1 · S/N 0298N3555RBeech A23 · S/N M-729N101PPSoko GALEB G-2 · S/N FVS-G-23101N196TBLearjet 24B · S/N 196N6093VCessna 172RG · S/N 172RG0576N138DBBreda Dana Marlowe RV6 · S/N 21487DBN112AVPiper PA-28-161 · S/N 28-7716227N49799Cessna 152 · S/N 15281322N8629FHughes Helicopters HUGHES 369D · S/N 670144DN368JKKull William L HAWK ARROW · S/N 001N73SJSchweizer 269C-1 · S/N 0335N764ZGYuneec International TYPHOON Q500 4K · S/N YU15261408B04B01N765FCDJI INSPIRE 1 · S/N W13DCD16030817N765XGYuneec International TYPHOON Q500 4K · S/N YU15261020B04B01N766GGParrot AR DRONE 2.0 · S/N PF721000BI3H311319N772QCParrot AR DRONE 2.0 · S/N PF721800BK5C066496N762YCDJI INSPIRE 1 · S/N W13DCD16031013N763YCYuneec TYPHOON Q500 4K · S/N YU15261525B04B01N6882ADJI PHANTOM 2 · S/N PH646070592N4477GKaribian Hurant THORP T18 · S/N 319N5716LAmerican AA-1 · S/N AA1-0116N905HHolbrook James R SLINGSHOT · S/N S8014N83116Aeronca 7AC · S/N 7AC1774N51971Fairchild M-62A · S/N T437189N41SXVoss Ronald M SONEX · S/N 0041N8189EMooney M20A · S/N 1460N61457Hy-Tek Hurricane ULTRA 103 · S/N JW101N3836JCessna 150G · S/N 15065136N8041CCessna 210-5(205) · S/N 205-0229N3091PPiper PA-23-150 · S/N 23-1009N1298HRand Kar Xair STANDARD · S/N 837N168ASPolaris FIB · S/N 993797N63212Hughes Helicopters 369E · S/N 0127EN8395FHughes Helicopters HUGHES 369D · S/N 880339DN2099SSchweizer 269C-1 · S/N 0345N413HTHughes TH-55 · S/N 67-16826(880933)N524JCCarnahan James P CX4 · S/N 87N1161WBell 47G-2A-1 · S/N 3333N4JDBeech 58 · S/N TH-145N50722Bell UH-1B · S/N 64-14100N7187GCessna 172K · S/N 17258887N8531FBell 47G-4 · S/N 3373N16256Schweizer 269C-1 · S/N 0252N8608GCessna 150F · S/N 15062708
Back to Panama City, FL