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.
N15460Sikorsky S-76C · S/N 760477N969LBBell Textron Canada 505 · S/N 65459N30DVHawker Siddeley HS.125 SERIES 700A · S/N NA0325N393SMAgustawestland Philadelphia AW139 · S/N 41393N848SCessna 150K · S/N 15071590N414EMCessna 414A · S/N 414A0500N9005GTextron 208B · S/N 208B5761N9562CConsolidated Vultee PBY-6A · S/N BU46679N94GRBeech T-34C-1 · S/N GM56N9563CConsolidated Vultee PBY-6A · S/N 64008N921XBBell Textron Canada 505 · S/N 65358N6014VCessna 172S · S/N 172S10133N875SAMD Helicopters 369FF · S/N 0160FFN93277Cessna 210L · S/N 21060338N402EMBeech C90 · S/N LJ-914N6526BCessna 210M · S/N 21062781N8RNNorth FORMULA ONE SPECIAL · S/N RN-1N767WABoeing 767-319ER · S/N 24876N3558DCessna 172S · S/N 172S8868N40266Robinson Helicopter R66 · S/N 1212N9006ATextron 208B · S/N 208B5728N251JCZ Jezek/Scalewings Aeropro SPZ SW-51 MUSTANG · S/N SW-51-001N950XBBell Textron Canada 505 · S/N 65455N2023EAeronca 7AC · S/N 7AC-5593N4669DCessna 172N · S/N 17272328N47686Piper PA-34-200T · S/N 34-7770427N5180TThrush S2R-510 · S/N 510-115N3521NPiper PA-31 · S/N 317912071N889EPTextron 172S · S/N 172S12889N890EPTextron 172S · S/N 172S12890N772CLBoeing 777-268 · S/N 28357N948BAAirbus A320-232 · S/N 2148N536TBell 206B · S/N 3195N724EXTextron 208B · S/N 208B5724N9436LBell Textron Canada 505 · S/N 65415N2BTAirbus Helicopters EC 130 T2 · S/N 8915N116MDTrimble UX5 · S/N 0000002375N640ABoeing 757-223 · S/N 24598N653ABoeing 757-223 · S/N 24611N657AMBoeing 757-223 · S/N 24615N658AABoeing 757-223 · S/N 24616N665AABoeing 757-223 · S/N 25299N671AABoeing 757-223 · S/N 25336N672AABoeing 757-223 · S/N 25337N693AABoeing 757-223 · S/N 26973N7667ABoeing 757-223 · S/N 25301N611BCSaab-Fairchild 340A · S/N 340A-060N174APCessna 172R · S/N 17280163N692WABeech 1900D · S/N UE160N366EVEurocopter SA 330J · S/N 1201
Back to Miami, FL