Matthews, NC
Registered aircraft · 39
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 = 'MATTHEWS' 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 = 'MATTHEWS' 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.
N111ZZPiaggio Aero Industries P180 · S/N 1145N1143BLuscombe 8A · S/N 5770N1185HPiper PA-28-151 · S/N 28-7715314N1189PPiper PA-23 · S/N 23-203N1321Logan Lance P RV8 · S/N 80231N161SWPiper PA-28-180 · S/N 28-3752N1676WBeech G33 · S/N CD-1299N1723PPiper PA-22-150 · S/N 22-2513N18189Cessna 150L · S/N 15073852N1908FCessna 172M · S/N 17256493N21530Mooney M20S · S/N 30-0030N28VPParks Eric D BEARHAWK · S/N 1074N35MEEngel Maynard G COUGAR MGE-1 · S/N PA19365N381MAAmerican Champion 7GCBC · S/N 1397-2005N43115Taylorcraft BC12-D · S/N 6774N4358GMacurdy Harold RANS S-9 · S/N 1291101N456RHGrumman American Avn. AA-5B · S/N AA5B1252N45WSCessna 177RG · S/N 177RG0465N464JWWaco Classic 2T-1A-2 · S/N 1219N469FSSunderland Richard RV-7 · S/N 73474N4804TPiper PA-32-300 · S/N 32-7240089N502FJames R Katz BOWERS FLY BABY 1A · S/N BR-549N507JPRockwell International 500-S · S/N 3262N5352RCessna 172F · S/N 17252882N5597Fisher STITS SA3B · S/N BF-P478N55MQWilson Rickey VARI-EZ · S/N 351N684CDCirrus Design SR22 · S/N 1786N695JPGulfstream AM Corp Comm Div 695A · S/N 96024N725MSTextron 560XL · S/N 560-6273N7929GCessna 182P · S/N 18263330N799ESCessna 414A · S/N 414A0657N80636Cessna 172M · S/N 17266684N812JPCirrus Design SR22 · S/N 2869N8164PPiper PA-24 · S/N 24-3419N818DVPiper PA-28-140 · S/N 28-26447N8699RStits Playboy SA3A · S/N P767N9056MCessna 210M · S/N 21062055N910GTCirrus Design SR22 · S/N 3153N965GCVans RV-12 · S/N 120544
Back to Matthews, NC