Gulfport, MS
Cancelled registrations · 59
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 = 'MS' AND d.registrant_city = 'GULFPORT' 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 = 'MS' AND d.registrant_city = 'GULFPORT' 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.
N83JKKleber John P LANCAIR LEGACY · S/N 117N922RVCessna 550 · S/N 550-0231N99328Cessna 182N · S/N 18260399N2124KLuscombe 8E · S/N 4851N702DADJI S1000+ · S/N 03P0014343N31344Aeronca 65-TL · S/N L5070TN1805YCessna 172C · S/N 17249405N3145HEngineering & Research ERCOUPE 415-C · S/N 3770N8184EMooney M20A · S/N 1455N3326APiper PA-22-150 · S/N 22-1601N6276YPiper PA-23-250 · S/N 27-3521N479MLMccarter Edgar H MEADOW LARK · S/N 1N24PAPurvis Vann R SUPER NOVA · S/N SN2-141N2315BPiper PA-38-112 · S/N 38-79A0005N11SKSaxon VARIEZE · S/N 367N4630QCessna 172M · S/N 17261729N1672Messersnipe PT 101 · S/N 2N6170UBeech A36 · S/N E-1964N80329Cessna 172M · S/N 17266523N761GSCessna 210M · S/N 21062251N7415DPiper PA-22-150 · S/N 22-5176N6131Bi-Fly Baby 1B · S/N 65-2N60SMBeech 200 · S/N BB50N13183Sikorsky H-5G · S/N 51-105N81707Piper PA-28-161 · S/N 28-8016281N209DTBeech V35B · S/N D-10169N39018Grumman American Avn. AA-1C · S/N AA1C0186N66PPMollere O J QUICKIE Q-2 · S/N 2039N1071SCessna 172N · S/N 17270503N6234PCessna 152 · S/N 15284989N4165FCessna 172 · S/N 46065N8774TCessna 182C · S/N 52674N8236XCessna 172C · S/N 17248736N444PPCessna 182Q · S/N 18266206N4889PPiper PA-23-250 · S/N 27-473N8836CPiper PA-22-135 · S/N 22-1449N12816Cessna 172M · S/N 17262286N5905DPiper PA-22-150 · S/N 22-4566N12513Cessna 172M · S/N 17262031N3030XCessna 150F · S/N 15064430N623Nardi FN-333 · S/N 003N1074ZPietenpol AIRCAMPER · S/N KM-1N3550NPiper J3C-65S · S/N 22785N7605HPiper PA-12 · S/N 12-480N500JRAero Commander 1121 · S/N 65N9257BCessna 175 · S/N 55057N9824EAeronca 11AC · S/N 11AC-1477N2670WMooney M20E · S/N 1076N7368TCessna 172A · S/N 46968N66362Piper J3C-65 · S/N 9411
Back to Gulfport, MS