American Agviation Inc
Earlier aircraft under this name · 65
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 = 'AMERICAN AGVIATION INC' OR list_contains(d.other_registrant_names, 'AMERICAN AGVIATION INC') 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 = 'AMERICAN AGVIATION INC' OR list_contains(d.other_registrant_names, 'AMERICAN AGVIATION INC') 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.
N141QCGrumman Acft ENG Cor-Schweizer G-164A · S/N 1002N2008Grumman Acft ENG Cor-Schweizer G-164B · S/N 349BN48397Grumman Acft ENG Cor-Schweizer G-164B · S/N 13BN5353Grumman G-164A · S/N 629N6380ZPiper PA-25 · S/N 25-501N6513KGrumman Acft ENG Cor-Schweizer G-164B · S/N 347BN6584Grumman G-164A · S/N 723N6712KGrumman Acft ENG Cor-Schweizer G-164B · S/N 432BN6809QGrumman Acft ENG Cor-Schweizer G-164B · S/N 317BN7801JGrumman G-164B · S/N 41BN8105KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 566BN8120KGulfstream-Schweizer A/C GULFSTREAM AM G-164D · S/N 6DN8285KGrumman Acft ENG Cor-Schweizer G-164B · S/N 646-BN8331KGulfstream-Schweizer A/C GULFSTREAM AM G-164D · S/N 16DN936QCGrumman Acft ENG Cor-Schweizer G-164A · S/N 1491N998QCGrumman Acft ENG Cor-Schweizer G-164A · S/N 1013N48399Grumman Acft ENG Cor-Schweizer G-164A · S/N 1573N6944KGrumman Acft ENG Cor-Schweizer G-164B · S/N 526BN6532KGrumman Acft ENG Cor-Schweizer G-164B · S/N 357BN6684QGrumman Acft ENG Cor-Schweizer G-164B · S/N 201BN580YGrumman G-164 · S/N 171N6780KGrumman Acft ENG Cor-Schweizer G-164B · S/N 471BN995QCGrumman American Avn. G-164B · S/N 540BN9635Grumman Acft ENG Cor-Schweizer G-164A · S/N 1295N8075KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 560BN5070Grumman Acft ENG Cor-Schweizer G-164A · S/N 1108N6701KGrumman Acft ENG Cor-Schweizer G-164B · S/N 430BN5254Grumman G-164A · S/N 534N941QCGrumman Acft ENG Cor-Schweizer G-164A · S/N 1575N8978HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1602N711RMCessna A188A · S/N 18800737N8945HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1581N8605HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1432N6568Grumman G-164A · S/N 707N7490Grumman Acft ENG Cor-Schweizer G-164A · S/N 970N5226FBoeing E75 · S/N 755919N48369Grumman Acft ENG Cor-Schweizer G-164B · S/N 5BN6896ZPiper PA-25-235 · S/N 25-2624N6848LPiper PA-25-235 · S/N 25-7405579N82378Piper PA-25-235 · S/N 25-7656111N7399Grumman Acft ENG Cor-Schweizer G-164A · S/N 946N8774HGrumman G-164A · S/N 1525N8725HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1493N605UGrumman G-164A · S/N 403N6586Grumman G-164A · S/N 725N6544Grumman G-164A · S/N 690N6631Grumman G-164A · S/N 761N717YGrumman G-164 · S/N 279N6204NBell 47G-5 · S/N 7876N9081RCessna A188B · S/N 18802103T
Back to American Agviation Inc