Miami, FL
Cancelled registrations · 5,508
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 = 'MIAMI' 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 = 'MIAMI' 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.
N8774URans S12XL · S/N 075950635N897USFokker F.28 MK 0100 · S/N 11392N209KWCessna 206H · S/N 20608013N156PBell 206B · S/N 611N5614YPiper PA-23-250 · S/N 27-2723N101NLLadas/Brown/Gargano AMATEUR BUILT · S/N A86POWN10590Moses Robert RIDGE RUNNER 3S · S/N 1030081445N116PYAirbus Industrie A300 B4-203 · S/N 116N515HCMcdonnell Douglas DC-9-82(MD-82) · S/N 49515N7872FCessna A150L · S/N A1500451N513HCMcdonnell Douglas DC-9-82(MD-82) · S/N 49513N6933RCessna T210H · S/N T210-0333N718TCThunder & Colt THUNDER AX8-105 S1 · S/N 2349N7675FCessna 337C · S/N 337-0899N419MTMcdonnell Douglas DC-9-82(MD-82) · S/N 49419N446AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49472N48WAGates Lear Jet 25B · S/N 136N27FTPiper PA-23-250 · S/N 27-7654174N298SCChief Aircraft Of America SKYCHIEF SS · S/N SS0807001N3101HRobinson Helicopter R44 · S/N 1610N1694PErick Magno & Assoc Pa DRIFTER · S/N UA005N20658Cessna 172M · S/N 17261467N2117APiper PA-18A-135 · S/N 18-1847N45WMMcadam W E CHRISTEN EAGLE II · S/N MCADAM-0001N1109CTextron B300 · S/N FL-1109N920CSCirrus Design SR22T · S/N 0286N294SWEmbraer EMB-120ER · S/N 120321N2575BNorthrop C-125 · S/N 48638N2576BNorthrop C-125 · S/N 48639N2577BNorthrop C-125 · S/N 48640N215TVBritish Aerospace BAE JETSTREAM 3101 · S/N 784N5502ECessna 150 · S/N 17002N5523AStinson 108 · S/N 1084292N55499Consolidated Vultee SNV-1 · S/N 791598N7210BBeech J35 · S/N D-5515N74389Bellanca 14-13-2 · S/N 1502N74690Curtiss Wright C-46D · S/N 33463N77569Piper J3C-65 · S/N 22061N7968QCessna 401B · S/N 401B0108N810WLCessna 310Q · S/N 310Q0439N9394FHughes 269B · S/N 0117N9479HBoeing E75 · S/N 758794N9520CConsolidated Vultee PBY-6A · S/N 64053N9531CConsolidated Vultee PBY-6A · S/N 46685N9532CConsolidated Vultee PBY-6A · S/N 46666N9533CConsolidated Vultee PBY-6A · S/N 64042N9553CConsolidated Vultee PBY-6A · S/N 46642N9554CConsolidated Vultee PBY-6A · S/N 64044N9585ZBeech TC-45H · S/N AF-124N53964Fairchild M-62A · S/N T435526
Back to Miami, FL