OpenAirDocs.org
Sproul Keith A

Registered aircraft · 27

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 = 'SPROUL KEITH A' OR list_contains(g.other_registrant_names, 'SPROUL KEITH A')
  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.

N155KAerostar International RAVEN S57-A · S/N S57A-3161Built 1994 · North Brunswick, NJN1766RSproul Keith A 77K-16 · S/N S-006North Brunswick, NJN24062Raven Industries S-40 · S/N S40-111Built 1967 · North Brunswick, NJN307PBRVB - Balonismo Promocional SS-32-PAN · S/N 2007104Built 2007 · North Brunswick, NJN3575GRaven Industries RALLY RX7 · S/N RX7-3205Built 1989 · North Brunswick, NJN3636ZAerostar International RAVEN S57-A · S/N S57A-3077Built 1989 · North Brunswick, NJN4012QAndrew Philip Richardson DBA A-B · S/N 248Built 2017 · North Brunswick, NJN48KXSproul Keith A SPROUL 48K-16 · S/N S-001Built 2002 · North Brunswick, NJN5276RAerostar International S-60A · S/N S60A-3266Built 2000 · North Brunswick, NJN5707DRaven S55A · S/N S55A-654Built 1980 · North Brunswick, NJN6309PAerostar International RAVEN S57-A · S/N S57A-3106North Brunswick, NJN6569XAerostar International RX-7 · S/N RX7-3148North Brunswick, NJN69MCAerostar International RX 8 · S/N RX8-3181Built 1993 · North Brunswick, NJN69MQAerostar International S53A · S/N S53A-3080Built 2000 · North Brunswick, NJN7055VAerostar International BRUT · S/N BRUT-3001Built 1995 · North Brunswick, NJN7097EAerostar International RXS-8 · S/N RXS8-3048Built 1994 · North Brunswick, NJN7164EAerostar International CAKE · S/N CAKE-3001Built 1996 · North Brunswick, NJN7171ZAerostar International S-51A · S/N S51A-3004Built 1996 · North Brunswick, NJN726PAAndrew Philip Richardson DRAGON · S/N 209Built 2016 · North Brunswick, NJN72KXSproul Keith A 72K-TET · S/N S-003Built 2004 · North Brunswick, NJN73KXSproul Keith A SPROUL 73K-24 · S/N S-002Built 2004 · North Brunswick, NJN83KXSproul Keith A 83K-16 · S/N S-005Built 2019 · North Brunswick, NJN9094MAerostar International RAVEN S49A · S/N S49A-3162Built 1993 · North Brunswick, NJN90PYCameron Balloons US O-90 · S/N 6639Built 2011 · North Brunswick, NJN9103YAerostar International S-60S · S/N S60S-3007North Brunswick, NJN9155SAerostar International RX 8 · S/N RX8-3184Built 1993 · North Brunswick, NJN941BSWhidden William S AX-6 · S/N 101Built 2003 · North Brunswick, NJ
Back to Sproul Keith A