Registered aircraft · 22

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

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 = 'JONES AVIATION INC' OR list_contains(g.other_registrant_names, 'JONES AVIATION INC') ORDER BY g.n_number

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 = 'JONES AVIATION INC' OR list_contains(g.other_registrant_names, 'JONES AVIATION INC')
  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 = 'JONES AVIATION INC' OR list_contains(g.other_registrant_names, 'JONES AVIATION INC')
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.

N194BPArrow Falcon Exporters UH-1H · S/N 67-17420Built 1967 · Biggs, CA N204GPBell-Colonial UH-1B · S/N 64-14073Built 1964 · Biggs, CA N2985YCessna 182E · S/N 18253985Built 1962 · Biggs, CA N3299KAyres S2R-T45 · S/N T45-012Built 1996 · Biggs, CA N40261Ayres S2R-G10 · S/N G10-158Built 1999 · Biggs, CA N447ATAyres S2R-G6 · S/N G6-103Built 1992 · Biggs, CA N4630Grumman Acft ENG Cor-Schweizer G-164A · S/N 1176Built 1973 · Biggs, CA N48452Grumman Acft ENG Cor-Schweizer G-164B · S/N 24BBuilt 1976 · Biggs, CA N48484Grumman Acft ENG Cor-Schweizer G-164B · S/N 43BBiggs, CA N5021XRockwell International S-2R · S/N 5053RBuilt 1975 · Biggs, CA N531MCGrumman Acft ENG Cor-Schweizer G-164C · S/N 7CBuilt 1978 · Biggs, CA N6180ABell UH-1B · S/N 62-1994Built 1962 · Biggs, CA N6524KGrumman Acft ENG Cor-Schweizer G-164B · S/N 352BBuilt 1977 · Biggs, CA N6535KGrumman Acft ENG Cor-Schweizer G-164C · S/N 3CBuilt 1977 · Biggs, CA N6587FCessna 150F · S/N 15063187Built 1966 · Biggs, CA N6596KGrumman Acft ENG Cor-Schweizer G-164C · S/N 6CBuilt 1978 · Biggs, CA N7763QCessna 310Q · S/N 310Q0263Built 1971 · Biggs, CA N83110Schweizer G-164D · S/N 11DBiggs, CA N8424VRockwell International S-2R · S/N 2184RBuilt 1976 · Biggs, CA N854MBell UH-1H · S/N 66-01062Biggs, CA N8929QRockwell International S-2R · S/N 2354RBuilt 1977 · Biggs, CA N911BVBell UH-1H · S/N 65-09785Built 1966 · Biggs, CA

Back to Jones Aviation Inc