OpenAirDocs.org
Petro Jerry R

Registered aircraft · 34

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 = 'PETRO JERRY R' OR list_contains(g.other_registrant_names, 'PETRO JERRY R')
  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.

N1039DRogers Eugene W PIEL EMERAUDE CP-128 · S/N 50Built 1982 · Williamsburg, VAN1084EAeronca 7AC · S/N 7AC4637Built 1946 · Williamsburg, VAN10966Curtiss Wright CW-1 · S/N 1144Built 1931 · Williamsburg, VAN110BTBaker Timothy C PAZMANY PL-2 · S/N 27Built 1988 · Williamsburg, VAN11601Franklin 90 · S/N 104Williamsburg, VAN12405Aeronca C-3 · S/N A-171Built 1931 · Williamsburg, VAN12674Fairchild 22 C7A · S/N 1033First renewal noticeBuilt 1932 · Williamsburg, VAN14550Aeronca C-3 · S/N A-504First renewal noticeWilliamsburg, VAN19386Waco YKS-7 · S/N 5212Built 1939 · Williamsburg, VAN19608Taylorcraft A · S/N 214Built 1937 · Williamsburg, VAN2290Petro Jerry R SORRELL SNS-2 · S/N 229Williamsburg, VAN23090Luscombe 8A · S/N 1014Built 1953 · Williamsburg, VAN2495EAeronca 7AC · S/N 7AC6077First renewal noticeWilliamsburg, VAN25106Luscombe 8A · S/N 1030First renewal noticeBuilt 1939 · Williamsburg, VAN26687Taylorcraft BL-65 · S/N 2029Built 1940 · Williamsburg, VAN2871Fairchild 22 C7A · S/N 1055First renewal noticeBuilt 1933 · Williamsburg, VAN2929EAeronca 7AC · S/N 7AC-6512Built 1946 · Williamsburg, VAN34135Commonwealth 185 · S/N 1846Built 1946 · Williamsburg, VAN4163HPiper PA-15 · S/N 15-47Built 1948 · Williamsburg, VAN417MDruine D-31 · S/N PFA-417-1CMBuilt 1958 · Williamsburg, VAN421WTravel Air 16-K · S/N 16-2003Built 1931 · Williamsburg, VAN42453Piper J3C-65 · S/N 14720Built 1945 · Williamsburg, VAN46070Taylorcraft DCO-65 · S/N 4769Built 1943 · Williamsburg, VAN46828Bucker-Jungman 131 · S/N 2009Built 1953 · Williamsburg, VAN7810DPiper PA-22-150 · S/N 22-5456Built 1957 · Williamsburg, VAN8166Minicab GY-20 · S/N D-1Williamsburg, VAN81819Smith Donald O SORRELL SNS-2 · S/N 98Williamsburg, VAN81PSAerotek PITTS S-2A · S/N 2081Built 1974 · Williamsburg, VAN82103Aeronca 7AC · S/N 7AC-729Built 1946 · Williamsburg, VAN82825Aeronca 7AC · S/N 7AC-1474Williamsburg, VAN82985Piper PA-18-150 · S/N 18-7809009Built 1977 · Williamsburg, VAN8351HEmigh TROJAN A-2 · S/N 54First renewal noticeBuilt 1950 · Williamsburg, VAN84770Aeronca 7AC · S/N 7AC-3484Built 1946 · Williamsburg, VAN9017RClark 12 · S/N 12-1Williamsburg, VA
Back to Petro Jerry R