Registered aircraft · 26

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 = 'FREEMAN HERITAGE COLLECTION LLC' OR list_contains(g.other_registrant_names, 'FREEMAN HERITAGE COLLECTION 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 = 'FREEMAN HERITAGE COLLECTION LLC' OR list_contains(g.other_registrant_names, 'FREEMAN HERITAGE COLLECTION 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 = 'FREEMAN HERITAGE COLLECTION LLC' OR list_contains(g.other_registrant_names, 'FREEMAN HERITAGE COLLECTION 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.

N11850Curtiss Wright JR CW1 · S/N 1224Built 1931 · Kingsbury, TX N14302Fairchild 22 C7D · S/N 915Built 1934 · Kingsbury, TX N16570Aeronca C-3 · S/N A706Built 1936 · Kingsbury, TX N1909EJunge Julius BLERIOT XI · S/N VA1Built 1997 · Kingsbury, TX N1917HFreeman Roger FOKKER DR.1 · S/N VA4Built 2003 · Kingsbury, TX N1918HSchuetzeberg Fritz FOKKER D-VII · S/N VA3Kingsbury, TX N1932GFreeman Roger M PIETENPOL SKY SCOUT · S/N VA2Kingsbury, TX N2096EAeronca 7AC · S/N 7AC-5666Built 1946 · Kingsbury, TX N308FHatch Vernon JN-4C · S/N C-308Built 2004 · Kingsbury, TX N318YWilcox GREAT LAKES REPLICA · S/N 6829-D-367Built 1976 · Kingsbury, TX N3229Curtiss Aeroplane & Motor CURTISS JN-4D · S/N 3229Kingsbury, TX N34310Meyers OTW · S/N 53Built 1941 · Kingsbury, TX N37AZPiper J-2 · S/N 1926Kingsbury, TX N3880PThomas Morse S4C · S/N 38802Kingsbury, TX N3885LThomas Morse S4C · S/N 38850Kingsbury, TX N38882Thomas Morse S4C · S/N 38882Kingsbury, TX N38923Freeman THOMAS MORSE S4C · S/N 1Built 1970 · Kingsbury, TX N4534Waco GXE · S/N 1381Built 1928 · Kingsbury, TX N592HRearwin 2000-C · S/N 103Kingsbury, TX N598EFStandard STANDARD J-1 · S/N T-4598Kingsbury, TX N6337Binski Norbert SOPWITH F 1 · S/N N6337Kingsbury, TX N7563Fairchild KR-31 · S/N 200Built 1928 · Kingsbury, TX N761VAThomas Morse S-5 · S/N 761Kingsbury, TX N8152Binski Norbert AUSTIN S E 5A · S/N F8157Kingsbury, TX N8225Eaglerock A-1 · S/N 790Kingsbury, TX N88313Piper J3C-65 · S/N 15931Kingsbury, TX

Back to Freeman Heritage Collection LLC