Registered aircraft · 31

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 = 'RED BARON LLC' OR list_contains(g.other_registrant_names, 'RED BARON 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 = 'RED BARON LLC' OR list_contains(g.other_registrant_names, 'RED BARON 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 = 'RED BARON LLC' OR list_contains(g.other_registrant_names, 'RED BARON 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.

N120SRMueller Lawrence D STARDUSTER TOO · S/N 1221LMMiddletown, DE N147LFFechter Lothar DEFIANT · S/N 161Middletown, DE N160DGGrunick Dl/Ashby Da RV-4 · S/N 3150Middletown, DE N248CKRiver Bay Aviation Cub CCX-2000 · S/N CCX-2000-0191Built 2024 · Middletown, DE N3939DCessna 182A · S/N 34639Built 1957 · Middletown, DE N4044MPiper PA-12 · S/N 12-2927Built 1947 · Kenai, AK N418MBCessna 182Q · S/N 18266154Built 1977 · Dickinson, ND N4254FCessna 172 · S/N 46154Built 1958 · Davis City, IA N42MXZacherl MXZ · S/N 01Built 2024 · Middletown, DE N489LAMaule M-4-180V · S/N 47007TMiddletown, DE N519MAAmerican Champion 7GCAA · S/N 489-2004Built 2004 · Middletown, DE N52BAsbell William E PITTS S-1E · S/N 8-0084Built 1988 · Middletown, DE N6041MStinson 108-3 · S/N 108-4041Built 1947 · Middletown, DE N617RCessna 180K · S/N 180-52979Middletown, DE N6205VCessna 172RG · S/N 172RG0590Built 1980 · Middletown, DE N6517ECessna 175 · S/N 56017Middletown, DE N65HSFiehtner PITTS S-1S · S/N 112144-KFMiddletown, DE N6821UMooney M20C · S/N 2536Middletown, DE N683EAHawker Beechcraft G36 · S/N E3863Built 2008 · Dickinson, ND N7019BPiper PA-22-150 · S/N 22-4270Middletown, DE N724DXZlin Aviation S R O SHOCK CUB · S/N CZ002Built 2018 · Middletown, DE N738QBCessna 172N · S/N 17270145Built 1977 · Middletown, DE N8235Aerotek PITTS S2S · S/N 1000Middletown, DE N897DCMaule MX-7-180A · S/N 20012CMiddletown, DE N89FFCsolkovits PITTS SPECIAL S-1S · S/N 288-HBuilt 1980 · Middletown, DE N89HCChappell Harold R JR PITTS S1S · S/N 7-0480Middletown, DE N900JLPiper PA-32R-300 · S/N 32R-7680181Pooler, GA N921TTZivko Aeronautics EDGE 540-T · S/N 2012Built 2001 · Middletown, DE N9394DCessna 172RG · S/N 172RG1150Built 1984 · Middletown, DE N948RCessna 177RG · S/N 177RG1318Built 1978 · Middletown, DE N9944DPiper PA-18A · S/N 18-7013Dickinson, ND

Back to Red Baron LLC