Gregory Vernon L
Registered aircraft · 85
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'GREGORY VERNON L' OR list_contains(g.other_registrant_names, 'GREGORY VERNON L') ORDER BY g.n_number"
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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'GREGORY VERNON L' OR list_contains(g.other_registrant_names, 'GREGORY VERNON L') ORDER BY g.n_number
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.
N2021HErco 415-C · S/N 2644N2120HErcoupe 415-D · S/N 2787N2244HEngineering & Research ERCOUPE 415-C · S/N 2867N2402HErcoupe 415-C · S/N 3027N2446HErcoupe 415-C · S/N 3071N2536HErcoupe 415-C · S/N 3161N2608HErcoupe 415-C · S/N 3233N2663HErcoupe 415-C · S/N 3288N2715HErcoupe 415-D · S/N 3340N2730HErcoupe 415-C · S/N 3355N2747HErcoupe 415-C · S/N 3372N2779JEngineering & Research 415-C · S/N 976N28939Ercoupe 415-C · S/N 34N28960Ercoupe 415-C · S/N 56N2915HErcoupe 415-C · S/N 3540N2962HErcoupe 415-C · S/N 3587N3007GForney F-1 · S/N 5699N3009GForney F-1 · S/N 5701N3027GForney F-1A · S/N 5722N3041HErcoupe 415-CD · S/N 3666N3043HEngineering & Research 415-C · S/N 3668N3067HErcoupe 415-CD · S/N 3692N3100HErcoupe 415-C · S/N 3725N3130HEngineering & Research 415-C · S/N 3755N3149HErcoupe 415-D · S/N 3774N37107Engineering & Research ERCOUPE 415-C · S/N 74N3785HEngineering & Research ERCOUPE 415-C · S/N 4410N3798HErcoupe 415-C · S/N 4423N3804HEngineering & Research ERCOUPE 415-CD · S/N 4505N3868HErcoupe 415-CD · S/N 4569N3878HErcoupe 415-D · S/N 4579N3926DErcoupe 415-CD · S/N 4627N3943HErcoupe 415-CD · S/N 4644N415RGForney 415-C · S/N 864N5609FAlon A2 · S/N A-209N5674FAlon A2 · S/N A-174N5678FAlon A2 · S/N A-178N5918FAlon A2 · S/N A-213N6363VAlon A2 · S/N A-39N6364VAlon A2 · S/N A-40N6534QAlon A2 · S/N A-134N72DSErcoupe 415-D · S/N 1012N747ECForney 415-C · S/N 747N7531CForney F-1 · S/N 5646N86991Engineering & Research ERCOUPE 415-C · S/N 164N86996Ercoupe 415-C · S/N 169N87042Ercoupe 415-C · S/N 215N87074Ercoupe 415-C · S/N 247N87091Ercoupe 415-C · S/N 264N87103Ercoupe 415-C · S/N 276
Back to Gregory Vernon L