Evergreen Equity Inc
Earlier aircraft under this name · 48
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 = 'EVERGREEN EQUITY INC' OR list_contains(d.other_registrant_names, 'EVERGREEN EQUITY 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 = 'EVERGREEN EQUITY INC' OR list_contains(d.other_registrant_names, 'EVERGREEN EQUITY 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.
N7929JBell 206B · S/N 663N105EHHiller UH-12E · S/N HA3027N9KCBell 206L-3 · S/N 51061N49552Aerospatiale SA316B ALOUETTE III · S/N 2275N204BBMesserschmitt-Boelkow-Blohm-Gm BO-105C · S/N S-57N62EVSikorsky HH-3F · S/N 1493N63EVSikorsky HH-3F · S/N 1497N110BGHughes Helicopters HUGHES 369D · S/N 610949DN1601GMcdonnell Douglas Helicopter 369E · S/N 0218EN115FHBell 206B · S/N 2737N90467Hiller UH-12E · S/N 2354N67092Aerospatiale SA316B ALOUETTE III · S/N 2190N103EHHiller UH-12E · S/N HA3026N827MSBell 212 · S/N 31205N134WJBeech B200C · S/N BL134N4996GAerospatiale SA316B ALOUETTE III · S/N 1233N57340Bell 206B · S/N 2998N500KMMesserschmitt-Boelkow-Blohm-Gm BO-105C · S/N S-76N9757CHiller UH-12E · S/N 2187N4997JAerospatiale SA316B ALOUETTE III · S/N 1316N49968Aerospatiale SA316B ALOUETTE III · S/N 1311N241LGBell 212 · S/N 30930N4776ZCessna U206G · S/N U20606020N4750RBell 205A-1 · S/N 30009N108FHBell 206B · S/N 2770N3889YBell 206B · S/N 3099N18FHBell 206B · S/N 2599N22952Bell 206B · S/N 3592N90471Hiller UH-12E · S/N 2363N1391XBell 47G-4A · S/N 7544N1601KMcdonnell Douglas Helicopter 369E · S/N 0202EN2784EMesserschmitt-Boelkow-Blohm BO-105S · S/N S-620N32MABell 206B · S/N 2178N600CKBell Helicopter Textron 206L-1 · S/N 45787N90469Hiller UH-12E · S/N 2358N27664Bell 212 · S/N 30974N5110YHughes Helicopters HUGHES 369D · S/N 510970DN52045Hughes Helicopters 369E · S/N 0083EN16008Mcdonnell Douglas Helicopter 369E · S/N 0215EN258EVBell 206L-3 · S/N 51493N254EVBell 206L-3 · S/N 51416N4997AAerospatiale SA316B ALOUETTE III · S/N 1312N212FHBell 206B · S/N 3026N4025SAyres S2R-T34 · S/N T34048DCN58087Bell 205A-1 · S/N 30134N9051TCessna 182C · S/N 52951N62190Aerospatiale SA315B · S/N 2366N90036Bell 205A-1 · S/N 30185
Back to Evergreen Equity Inc