Registered aircraft · 32

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

N101CGCessna 208B · S/N 208B5191Built 2015 · Anchorage, AK N13AVGippsland GA-8 · S/N GA8-03-028Built 2003 · Anchorage, AK N1587UCessna 207 · S/N 20700187Anchorage, AK N17GNCessna 207A · S/N 20700693Built 1981 · Anchorage, AK N207YHCessna 207A · S/N 20700637Built 1980 · Anchorage, AK N208SMCessna 208B · S/N 208B0749Built 1999 · Anchorage, AK N269TDCessna 208B · S/N 208B2069Built 2008 · Anchorage, AK N27471Piper PA-31-350 · S/N 31-7852018Built 1977 · Anchorage, AK N28KEPiper PA-31-350 · S/N 31-8152049Anchorage, AK N40796Piper PA-31-350 · S/N 31-8152084Built 1981 · Anchorage, AK N4105DPiper PA-31-350 · S/N 31-8252027First renewal noticeBuilt 1981 · Anchorage, AK N4107QPiper PA-31-350 · S/N 31-8253008Built 1982 · Anchorage, AK N502GVTextron 208B · S/N 208B5249Anchorage, AK N521AVGippsaero GA8 · S/N GA8-13-199Built 2013 · Anchorage, AK N523AVGippsaero GA8 · S/N GA8-14-201Built 2014 · Anchorage, AK N524AVGippsaero GA8 · S/N GA8-15-214Built 2015 · Anchorage, AK N524ERPiper PA-31-350 · S/N 31-8152132Built 1981 · Anchorage, AK N55SRBeech 200 · S/N BB-445Built 1978 · Anchorage, AK N578GVGippsland GA-8 · S/N GA8-04-066Built 2004 · Anchorage, AK N606CPGippsland GA-8 · S/N GA8-03-036Built 2003 · Anchorage, AK N611GVTextron 208B · S/N 208B5349Built 2017 · Anchorage, AK N613CPGippsland GA-8 · S/N GA8-04-062Anchorage, AK N6908MCessna 207A · S/N 20700672Built 1980 · Anchorage, AK N73067Cessna 207A · S/N 20700558Built 1979 · Anchorage, AK N7384UCessna 207A · S/N 20700431Built 1978 · Anchorage, AK N795JTextron 208B · S/N 208B5550Built 2019 · Anchorage, AK N916RKGippsaero PTY GA8 · S/N GA8-12-176Built 2012 · Anchorage, AK N9399MCessna 207A · S/N 20700652Built 1980 · Anchorage, AK N9651MCessna 207A · S/N 20700715Built 1981 · Anchorage, AK N9728MCessna 207A · S/N 20700721Built 1981 · Anchorage, AK N9946MCessna 207A · S/N 20700588Built 1980 · Anchorage, AK N9948MCessna 207A · S/N 20700759Built 1982 · Anchorage, AK

Back to Grant Aviation Inc