Agusta Aerospace Corp
Earlier aircraft under this name · 107
Cancelled registrations that named this owner when they ended, newest first.
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_name = 'AGUSTA AEROSPACE CORP' OR list_contains(d.other_registrant_names, 'AGUSTA AEROSPACE CORP') 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_name = 'AGUSTA AEROSPACE CORP' OR list_contains(d.other_registrant_names, 'AGUSTA AEROSPACE CORP') 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.
N391SHAgusta Aerospace AW119 MKII · S/N 14772N305YSAgusta Aerospace AW139 · S/N 41267N366SHAgusta Aerospace AW119 MKII · S/N 14759N218YSAgusta Aerospace AW119 MKII · S/N 14767N376SHAgusta Aerospace AW119 MKII · S/N 14764N478SMAgusta Aerospace AW139 · S/N 41257N470SMAgusta Aerospace AW139 · S/N 41250N209YSAgusta AW139 · S/N 31283N215YSAgusta AW139 · S/N 31277N468SMAgusta Aerospace AW139 · S/N 41247N467SMAgusta Aerospace AW139 · S/N 41245N211YSAgusta Aerospace AW119 MKII · S/N 14763N466SMAgusta Aerospace AW119 MKII · S/N 14758N377SHAgusta Aerospace AW119 MKII · S/N 14765N458SMAgusta Aerospace AW139 · S/N 41238N374SHAgusta Aerospace AW119 MKII · S/N 14762N419SMAgusta Aerospace AW139 · S/N 41227N453SMAgusta Aerospace AW139 · S/N 41230N461SMAgusta Aerospace AW119 MKII · S/N 14755N455SMAgusta Aerospace AW139 · S/N 41236N454SMAgusta Aerospace AW139 · S/N 41232N459SMAgusta Aerospace AW139 · S/N 41241N460SMAgusta Aerospace AW139 · S/N 41248N207SMAgusta Aerospace AW119 MKII · S/N 14733N368SHAgusta Aerospace AW139 · S/N 41228N372SHAgusta A109S · S/N 22165N229SMAgusta Aerospace AW119 MKII · S/N 14739N417SMAgusta Aerospace AW139 · S/N 41226N204YSAgusta A109S · S/N 22160N370SHAgusta Aerospace AW139 · S/N 41233N223SMAgusta Aerospace AW119 MKII · S/N 14736N363SHAgusta Aerospace AW119 MKII · S/N 14748N413SMAgusta Aerospace AW139 · S/N 41225N420SMAgusta Aerospace AW139 · S/N 41222N207YSAgusta Aerospace AW119 MKII · S/N 14754N346SHAgusta Aerospace AW119 MKII · S/N 14749N202YSAgusta Aerospace AW119 MKII · S/N 14752N203YSAgusta Aerospace AW119 MKII · S/N 14753N410SMAgusta Aerospace AW139 · S/N 41231N408SMAgusta A109S · S/N 22121N117YSAgusta AW139 · S/N 41207N248SMAgusta Aerospace AW139 · S/N 41212N403SMAgusta Aerospace AW139 · S/N 41220N361SHAgusta A109S · S/N 22142N302SHAgusta Aerospace AW119 MKII · S/N 14724N249SMAgusta Aerospace AW139 · S/N 41214N405SMAgusta Aerospace AW139 · S/N 41218N225SMAgusta Aerospace AW139 · S/N 41213N341SHAgusta Aerospace AW139 · S/N 41215N395GPAgusta Aerospace AW139 · S/N 41217
Back to Agusta Aerospace Corp