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.
N27FACessna 172S · S/N 172S10420N109ALockheed 749-79 · S/N 2530N412TTBell 412EP · S/N 36252N74726Mooney M20A · S/N 1726N101KBCessna 310N · S/N 310N-0183N6693BCessna 310C · S/N 35793N63752Piper PA-23-250 · S/N 27-7754086N474Mcdonnell Douglas DC-9-82(MD-82) · S/N 49649N496AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49734N6198QCessna 152 · S/N 15285190N719SFPiper PA-31-350 · S/N 31-7852057N6901CLockheed 1049-54 · S/N 4015N6905CLockheed 1049-54 · S/N 4019N6908CLockheed 1049-54 · S/N 4022N6909CLockheed 1049-54 · S/N 4023N6910CLockheed 1049-54 · S/N 4024N71939Luscombe 8A · S/N 3366N494AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49732N6337PPiper PA-24 · S/N 24-1447N640DRAnimusoft ALIVE.HOVER MINI · S/N ASAHM00001N641DRAnimusoft ALIVE.HOVER · S/N ASAH00001N642DRDJI PHANTOM 4 · S/N 07DDD550A10792N97EGDJI INSPIRE 1 RAW · S/N W21ADC23020195N9138UCessna 150M · S/N 15078089N864GPTextron 208B · S/N 208B5520N7617XDJI INSPIRE 1 · S/N W13DCC17030351N36377Taylorcraft L-2M · S/N 4118N3638FNorth American SNJ-5 · S/N NAA5622N5JQCessna P337H · S/N P3370328N4777BCessna 152 · S/N 15283628N851VXBell Helicopter Textron Canada 505 · S/N 65077N9559BCessna 172RG · S/N 172RG0880N587JABritten-Norman BN-2 ISLANDER · S/N C-40N67515Cessna 152 · S/N 15281883N782QPDJI PHANTOM 2 · S/N PH646019834N7857XSkyhigh Media MONSTER X · S/N MX014RN789BVMcdonnell Douglas DC-9-83(MD-83) · S/N 49789N83EGDJI INSPIRE 1 · S/N WISDBL29020068N476AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49651N124VAVulcanair S P A VULCANAIR V1.0 · S/N 1008N3053JCessna 150E · S/N 15061153N68TCThunder & Colt Airborne Amer AX 9-140 S II · S/N 1287USAN7611XDJI INSPIRE 1 · S/N W1DCC17030038N89EGDJI S1000 · S/N 02V0020925N970TCThunder Balloons AX9-140 SII · S/N 1483N12803Cessna 172M · S/N 17262273N24349Taylorcraft BF · S/N 1685N861LTTextron 208B · S/N 208B5509N2359MPiper PA-12 · S/N 12-1503N498KCessna T207A · S/N 20700624
Back to Miami, FL