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

N128AVPiper PA-28 · S/N 28-8516007Built 1984 · Xenia, OH N17324Piper PA-28-161 · S/N 287916050Built 1979 · Xenia, OH N1946HPiper PA-28-161 · S/N 28-7716067Built 1977 · Xenia, OH N21RGCessna T207 · S/N 20700066Built 1969 · Xenia, OH N2202PPiper PA-23 · S/N 23-812Built 1956 · Xenia, OH N2553YPiper PA-28-161 · S/N 28-8516079Built 1985 · Xenia, OH N2565MPiper PA-28-181 · S/N 28-7890257Built 1977 · Xenia, OH N263MAAmerican Champion 8KCAB · S/N 968-2004Built 2004 · Xenia, OH N263SRCirrus Design SR22 · S/N 2512Built 2007 · Xenia, OH N33424Piper PA-28-151 · S/N 28-7515337Built 1975 · Xenia, OH N42787Piper PA-28-151 · S/N 28-7415400Built 1974 · Xenia, OH N4385WPiper PA-28-161 · S/N 28-8516002Built 1984 · Xenia, OH N49CBCessna 337G · S/N 33701551Built 1973 · Xenia, OH N5060VCirrus Design SR22 · S/N 0829Built 2004 · Xenia, OH N51WMCessna 337D · S/N 337-1140Xenia, OH N52076Cessna 177RG · S/N 177RG1163Xenia, OH N5428LCessna 152 · S/N 15284313Built 1980 · Xenia, OH N55414Piper PA-34-200 · S/N 34-7350212Built 1973 · Xenia, OH N56849Piper PA-28-151 · S/N 28-7415018Built 1973 · Xenia, OH N5897VPiper PA-28-161 · S/N 28-7716212Built 1977 · Xenia, OH N5932VPiper PA-28R-201 · S/N 28R-7737076Xenia, OH N73266Cessna 207A · S/N 20700574Built 1979 · Xenia, OH N777RYCirrus Design SR22 · S/N 0777Built 2003 · Xenia, OH N7963FPiper PA-28-151 · S/N 28-7715251Built 1976 · Xenia, OH N802UCessna 207 · S/N 20700067Built 1969 · Xenia, OH N8229PPiper PA-28-181 · S/N 28-8090330Built 1980 · Xenia, OH N83039Piper PA-28-161 · S/N 28-8116097Built 1980 · Xenia, OH N8395YPiper PA-28RT-201 · S/N 28R-8118072Built 1981 · Xenia, OH N8408LPiper PA-28-161 · S/N 28-8116261Built 1981 · Xenia, OH N9114DPiper PA-28-181 · S/N 2890032Built 1987 · Xenia, OH N937MAPiper PA-28-151 · S/N 28-7415627Built 1974 · Xenia, OH

Back to Macair Aviation LLC