Registered aircraft · 20

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 = 'AMELIA REID AVIATION LLC' OR list_contains(g.other_registrant_names, 'AMELIA REID AVIATION LLC') 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 = 'AMELIA REID AVIATION LLC' OR list_contains(g.other_registrant_names, 'AMELIA REID AVIATION LLC')
  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 = 'AMELIA REID AVIATION LLC' OR list_contains(g.other_registrant_names, 'AMELIA REID AVIATION LLC')
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.

N11681Bellanca 7KCAB · S/N 308-72Built 1972 · San Jose, CA N12234Cessna 172M · S/N 17261896Built 1973 · San Jose, CA N1701HBellanca 7KCAB · S/N 454-74Built 1974 · San Jose, CA N1806GChampion 7ECA · S/N 573Built 1968 · San Jose, CA N2508ZBellanca 7ECA · S/N 1249-78Built 1978 · San Jose, CA N4203VCessna 170 · S/N 18559Built 1948 · Wilton, CA N5032GBellanca 7ECA · S/N 1283-79Built 1978 · San Jose, CA N5119TChampion 7ECA · S/N 200Built 1966 · San Jose, CA N53456Cessna 172P · S/N 17274754Built 1981 · San Jose, CA N53893Bellanca 7ECA · S/N 1140-76Built 1975 · San Jose, CA N5637MMaule M-5-180C · S/N 8008CBuilt 1980 · San Jose, CA N61637Cessna 172M · S/N 17264691Built 1975 · San Jose, CA N616SFCessna 172RG · S/N 172RG0740Built 1980 · San Jose, CA N66459Cessna 150M · S/N 15076063Built 1974 · San Jose, CA N6796HCessna 172M · S/N 17265584Built 1975 · San Jose, CA N88353Bellanca 7KCAB · S/N 521-75Built 1975 · San Jose, CA N9091LChampion 7ECA · S/N 784-70Built 1970 · San Jose, CA N968RCCessna 172P · S/N 17276126Built 1984 · San Jose, CA N98485Cessna 172P · S/N 17276299Built 1985 · San Jose, CA N990WYBellanca 7ECA · S/N 1168-76Built 1976 · San Jose, CA

Back to Amelia Reid Aviation LLC