Registered aircraft · 17

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 = 'STATE OF NORTH CAROLINA' OR list_contains(g.other_registrant_names, 'STATE OF NORTH CAROLINA') 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 = 'STATE OF NORTH CAROLINA' OR list_contains(g.other_registrant_names, 'STATE OF NORTH CAROLINA')
  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 = 'STATE OF NORTH CAROLINA' OR list_contains(g.other_registrant_names, 'STATE OF NORTH CAROLINA')
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.

N103NCCessna 182S · S/N 18280647Built 1999 · Raleigh, NC N350NCEurocopter AS 350 B3 · S/N 3472Built 2001 · Raleigh, NC N3521KCessna 182T · S/N 18280998Built 2002 · Raleigh, NC N370NCEurocopter AS 350 B3 · S/N 4379Built 2008 · Raleigh, NC N42058Cessna 182S · S/N 18280441Built 1998 · Raleigh, NC N421NCBell UH-1H · S/N 64-13544Built 1964 · Raleigh, NC N6132NBell UH-1H · S/N 66-16040Raleigh, NC · Co-owner with Usda Forest Service Fepp N6492GCessna 182T · S/N 18281411Built 2004 · Raleigh, NC N67NHBell UH-1H · S/N 6717282Built 1967 · Raleigh, NC N735AXCessna A185F · S/N 18504439Built 1985 · Raleigh, NC N735DNCessna A185F · S/N 185-04441Built 1985 · Raleigh, NC N735EDCessna A185F · S/N 185-04443Built 1985 · Morehead City, NC N735EKCessna A185F · S/N 185-04444Built 1985 · Raleigh, NC N800NCAir Tractor AT-802 · S/N 802-0671Built 2016 · Raleigh, NC N801NCAir Tractor AT-802A · S/N 802A-0724Built 2017 · Raleigh, NC N920NCCessna 182S · S/N 18280920Built 2000 · Raleigh, NC N9542WCessna 182S · S/N 18280136Built 1998 · Raleigh, NC

Back to State Of North Carolina