Ft Pierce, FL
Cancelled registrations · 68
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 = 'FT PIERCE' 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 = 'FT PIERCE' 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.
N47744Piper PA-34-200T · S/N 34-7870026N1081MConsolidated Vultee BT-13 · S/N 791435N1061MBoeing N2S-3 · S/N 757501N598MCessna 172 · S/N 36838N4791JBeech A23-24 · S/N MA-197N705GGrumman G-159 · S/N 152N88616Piper J3C-65 · S/N 16244N4288BBeech F35 · S/N D-4219N51BRRobinson S M Boris RV-4 · S/N 3598N432PAPiper PA-44-180 · S/N 4496058N75206Piper PA-28-151 · S/N 28-7615270N6989SCessna 150H · S/N 15067689N2208PPiper PA-23 · S/N 23-818N78719Piper PA-11 · S/N 111471N6710SCessna 150H · S/N 15067510N7170KPiper PA-18 · S/N 18-390N4928ZCessna U206G · S/N U20606050N4890APiper PA-18A-135 · S/N 18-4991N3636GSeair BG-12A · S/N 12020N6JWGrumman G-1159 · S/N 138N28843Luscombe 8C · S/N 1585N4724SPiper PA-32-260 · S/N 32-1163N1978PMitsubishi MU-2B-20 · S/N 212N29RDDean George L SUPER BABY LAKES · S/N 8017-C-772BN31534Sample Jay W MITCHELL B10A · S/N 233N966BBeagle B.206 SERIES 2 · S/N 057N66163Boeing N2S-3 · S/N 751220N15HLPiper PA-23-250 · S/N 27-4162N6330YPiper PA-23-250 · S/N 27-3590N92477Nixon Brian TITAN TORNADO · S/N D94XXXC0HK0106N6HVCessna 172N · S/N 17273778N5380ACessna 310B · S/N 35580N4537ZPiper PA-22-108 · S/N 22-8042N4862SPiper PA-32-260 · S/N 32-1297N4870ZCessna TU206G · S/N U20606038N37103Cessna 404 · S/N 404-0109N6875HPiper J3C-65 · S/N 20091N139MCSnow 600-S2C · S/N 600-1297CN4BYCessna 150F · S/N 15063739N500MAGulfstream Aerospace G1159B · S/N 119N410PAPiper PA-28R-201 · S/N 2844043N1712SAero Commander 600 S-2D · S/N 600-1342DN8664UCessna 172F · S/N 17252567N151MSSkinner Marvin D P-51D MUSTANG · S/N MLB-1N5HVBeech 77 · S/N WA-112N9672TCessna 210 · S/N 57472N65NCCessna T303 · S/N T30300160N1738HCessna 310C · S/N 35838N6998QBeech B23 · S/N M1105N6226MStinson 108-3 · S/N 1084226
Back to Ft Pierce, FL