Catawba, NC
Registered aircraft · 38
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
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_state = 'NC' AND g.registrant_city = 'CATAWBA' 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_state = 'NC' AND g.registrant_city = 'CATAWBA' 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.
N14JWZlin Aviation Sro SAVAGE · S/N 0107N1588XPiper PA-28-235 · S/N 28-7510087N15XBeech 58P · S/N TJ-226N2214Jungster 1 · S/N 130N2328ZBeech 23 · S/N M-31N2475DCessna 170B · S/N 20627N298TRRhodenbaugh Timothy C PULSAR SERIES 1 · S/N 001N3376CBeech F35 · S/N D-4043N33CAPiper PA 46-350P · S/N 4636748N3548HErcoupe 415-C · S/N 4173N35988Piper J4E · S/N 4-1471N40014Robinson Helicopter R44 · S/N 2825Non-citizen corporation, flight hours not reportedN4090FCessna 172 · S/N 36990N411KFFrank Kevin WHEELER EXPRESS · S/N KF01N4269GFloyd Thomas H SEAREY · S/N 1DK413CN426JMJenkins Howard M RV-6A · S/N 60191N4AUMooney M20C · S/N 2430N511ECessna 172A · S/N 47107N515BLRhodenbaugh Tim AIRCAM · S/N 003N527CMCostruzioni Aeronautiche Tecna P2010 · S/N 107/USN5327KRyan NAVION B · S/N NAV-4-2227-BN53676Cessna 337G · S/N 33701775N7263JPiper PA-28-140 · S/N 28-24548N73TXLancair LC-40-550FG · S/N 40034N74WKKennedy Wade J RV7A · S/N 73240N78827Piper PA-11 · S/N 11-1601N8262EPiper PA-28-181 · S/N 28-8190033N83436Champion 7AC · S/N 7AC-2103N83638Aeronca 7AC · S/N 7AC-2316N83655Aeronca 7AC · S/N 2333N8931MBeech 35-B33 · S/N CD-699N8939LPiper PA-25-235 · S/N 25-5404N91162Cessna 182P · S/N 18261960N9120Schuster John R WOODY PUSHER · S/N 207N914CPTimothy C Rhodenbaugh SLING TSI · S/N 1N9611JPiper PA-28-180 · S/N 28-3761N965QBeech P35 · S/N D-6843N9665BCessna 180 · S/N 32962
Back to Catawba, NC