Registered aircraft · 22

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 = 'ALBERTSON JAMES M' OR list_contains(g.other_registrant_names, 'ALBERTSON JAMES M') 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 = 'ALBERTSON JAMES M' OR list_contains(g.other_registrant_names, 'ALBERTSON JAMES M')
  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 = 'ALBERTSON JAMES M' OR list_contains(g.other_registrant_names, 'ALBERTSON JAMES M')
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.

N1533GBalloon Works FIREFLY 6B · S/N 10203Westville, FL N26VCPiper PA-18 105 · S/N 18-2328Westville, FL N27120Piper J3L-65 · S/N 4385Westville, FL N31187Head Balloons AX8-88 · S/N 326Slocomb, AL N3292ZPiper PA-18 · S/N 18-7229Built 1959 · Westville, FL N333CMCessna 120 · S/N 12105Slocomb, AL N34TFGrumman American Avn. G-164A · S/N 1724Slocomb, AL N3848ASchweizer SGU 2-22CK · S/N 65First renewal noticeWestville, FL N4513YPiper PA-25-235 · S/N 25-4019Built 1966 · Slocomb, AL N45256Cessna 150M · S/N 15076808Built 1975 · Westville, FL N48625Grumman Acft ENG Cor-Schweizer G-164B · S/N 90BBuilt 1976 · Slocomb, AL N49621Piper J3L-65 · S/N G-189Westville, FL N5320VHiller UH-12C · S/N 786Built 1956 · Slocomb, AL N5573ECessna 150 · S/N 17073Built 1958 · Westville, FL N70510Piper J3C-85 · S/N 17516First renewal noticeBuilt 1946 · Westville, FL N70587Piper J3C-65 · S/N 17596First renewal noticeBuilt 1946 · Westville, FL N70705Piper J3C-65 · S/N 17722Built 1946 · Westville, FL N7202ECessna 182B · S/N 52202Built 1959 · Westville, FL N723JSPiper PA-30 · S/N 30-1512Built 1967 · Westville, FL N7330ZPiper PA-25-235 · S/N 25-3230Built 1965 · Slocomb, AL N85880Aeronca 11AC · S/N 11AC-301Built 1946 · Westville, FL N90014Balloon Works FIREFLY 7 · S/N F7-472First renewal noticeWestville, FL

Back to Albertson James M