Registered aircraft · 32

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 = 'MARC INC' OR list_contains(g.other_registrant_names, 'MARC INC') 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 = 'MARC INC' OR list_contains(g.other_registrant_names, 'MARC INC')
  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 = 'MARC INC' OR list_contains(g.other_registrant_names, 'MARC INC')
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.

N101MCSwearingen SA-226T · S/N T234Built 1973 · Bolton, MS N111SDCessna T-310P · S/N 310P0200Built 1969 · Bolton, MS N1463PPiper PA-23-150 · S/N 23-526Built 1956 · Bolton, MS N146JPiper PA-31-350 · S/N 31-7852005Built 1977 · Bolton, MS N196AGPiper PA-31-350 · S/N 31-7952036Bolton, MS N303ABCessna T303 · S/N T30300028Built 1981 · Bolton, MS N310JGCessna T310R · S/N 310R1567Built 1979 · Bolton, MS N314BBCessna T310R · S/N 310R1836Bolton, MS N314HBCessna T310R · S/N 310R1586Built 1979 · Bolton, MS N31JVSwearingen SA227-TT · S/N TT-453Built 1981 · Bolton, MS N3589XPiper PA-31-350 · S/N 31-8052138Built 1980 · Bolton, MS N359CPiper PA-31-325 · S/N 31-7912109Bolton, MS N364NYCessna T310R · S/N 310R-0718Bolton, MS N4109APiper PA-23-250 · S/N 27-4459Built 1970 · Bolton, MS N45014Piper PA-31-350 · S/N 31-8052171Built 1980 · Bolton, MS N527BMCessna P206 · S/N P2060035Bolton, MS N5337CCessna T310R · S/N 310R1543Built 1978 · Bolton, MS N5521FPiper PA-28-140 · S/N 28-24863Built 1968 · Brandon, MS N5821MCessna 310P · S/N 310P0121Built 1969 · Bolton, MS N6114VBeech S35 · S/N D-7780Built 1965 · Bolton, MS N6184QCessna 320F · S/N 320F-0034Built 1968 · Bolton, MS N6GRPiper PA-31-350 · S/N 31-7752130Bolton, MS N727MAPiper PA-31-350 · S/N 31-7652048Built 1976 · Bolton, MS N737SBeech 95-B55 (T42A) · S/N TC-1297Built 1969 · Bolton, MS N765KPPiper PA-31-350 · S/N 31-8253012Built 1982 · Bolton, MS N818BRPiper PA-31-350 · S/N 318152102Built 1981 · Bolton, MS N890HPiper PA-31-350 · S/N 31-8052194Built 1980 · Bolton, MS N900CGPiper PA-31-325 · S/N 31-7612002Built 1975 · Bolton, MS N931SAPiper PA-31-350 · S/N 317552036Built 1975 · Bolton, MS N95764Cessna 182Q · S/N 18266622Built 1978 · Bolton, MS N973JMCessna 182Q · S/N 18266734Built 1978 · Bolton, MS N9900Swearingen SA-226T · S/N T-266Built 1976 · Bolton, MS

Back to Marc Inc