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.
N282WABoeing 727-247 · S/N 21484N3308LDouglas DC-9-14 · S/N 45703N8244KStetson William SPORT A-1 · S/N 95-01N427FBDouglas DC-8F-54 · S/N 45684N611SCRobinson Helicopter R22 BETA · S/N 3869N93RAAero Commander 680W · S/N 1722-2N95141Quicksilver Enterprises QUICKSILVERMXIISPRIN · S/N SPRINT II 557N705DSBell 206L-3 · S/N 51488N17HRCessna 172H · S/N 17255645N40443Kurtz Jay B CAPELLA XS · S/N 993N61FBRockwell International NA-265-60 · S/N 30680N97277Cessna 172P · S/N 17276172N4092PTextron G36 · S/N E-4092N379CPPiper PA-23-250 · S/N 27-2737N56CABubel John A BUCCANEER II · S/N B2B-K026N203LRans S12XL · S/N 07950637N596AHLockheed L-1011-385-3 · S/N 193J1196N627WDBritten-Norman BN2A-26 ISLANDER · S/N 627N663ASPiper PA-31-310 · S/N 31-529N731BARobinson Helicopter R22 BETA · S/N 3013N784ALMcdonnell Douglas DC-8-63F · S/N 46135N458XLAerospatiale AS350 B2 ECUREUIL · S/N 1688N9270HGrumman G-44 · S/N 1384N9876CNorth American TB-25N · S/N 4428874AN98821Piper J3C-75S · S/N 19067N9921ZBeech C-45H · S/N AF-724N6550KRepublic RC-3 · S/N 816N6933CLockheed 1049H-82 · S/N 4826N7277CNorth American T-28A · S/N 49-1668AN7417ZPiper PA-25-235 · S/N 25-3389N74659Lockheed 18-56 · S/N 2190N7466CNorth American AT-6 · S/N 4482487N74694Consolidated PBY-5A · S/N 46631N74830Douglas A-26B · S/N 41-39298RN7486XCessna 172B · S/N 17247986N7511ZPiper PA-25-235 · S/N 25-3548N7662MCessna 175 · S/N 55962N774RDouglas DC-7B · S/N 44868N7822QCessna 402A · S/N 402A0122N7867QCessna 310Q · S/N 310Q0650N7869UCessna 172F · S/N 17251869N7877BConsolidated Vultee PBY-6A · S/N 46659N7878BConsolidated Vultee PBY-6A · S/N 46650N7880BConsolidated Vultee PBY-6A · S/N 46639N7883BConsolidated Vultee PBY-6A · S/N 64005N7884BConsolidated Vultee PBY-6A · S/N 64033N8005NPiper PA-28-140 · S/N 28-25246N82776Aeronca 7AC · S/N 7AC-1423N8338Lockheed 1049G · S/N 4616N8579EAeronca 7GC · S/N 7GC100
Back to Miami, FL