Concord, NC
Registered aircraft · 115
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 = 'CONCORD' 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 = 'CONCORD' 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.
N100DVVogt Richard G CUBY AT ELEVEN · S/N 1000N108WGStinson 108-3 · S/N 1084124N110SQCessna 172S · S/N 172S10384N125FLPiper PA-34-200 · S/N 34-8170025N126WABeech C90 · S/N LJ1093N129JTTextron 182T · S/N 18283288N12SSTextron 525C · S/N 525C-0219N133MHLockheed T-33A · S/N 51-17463N1342TPiper PA-28R-200 · S/N 28R-7235265N1450SCessna 182P · S/N 18264998N1484XPiper PA-28-180 · S/N 28-7505233N148LCCirrus Design SR22T · S/N 0048N1520EChampion 7AC · S/N 7AC-5083N1541JPiper PA-28-140 · S/N 28-23943N160DCCessna 421C · S/N 421C0856N1705VCessna 172M · S/N 17263718N189QBeech D95A · S/N TD-628N212CHBeech 58 · S/N TH-1165N214CHBeech 58 · S/N TH-1160N2255DCessna 170B · S/N 20407N225PMPiper PA-46-701TP · S/N 46020096N23207Cessna T206H · S/N T20608750N2386RPiper PA-28-180 · S/N 28-5602N26717Gulfstream American AA-5A · S/N AA5A0671N27117Beech A36 · S/N E-1416N2981KCessna 180K · S/N 18053145N3135WBeech V35B · S/N D-9538N3178YCessna 182E · S/N 18254178N323SQAircraft Mfg & Development CH 601XL SLSA · S/N 601-009SN3257ECessna 172N · S/N 17271482N3365Kasha ACEY DEUCY P-70 · S/N 24N3413VCessna 150M · S/N 15076493N34ZAZenair CH 2000 · S/N 200034N351GFBeech B300 · S/N FL-129N374Whittman Tail Wind W9L · S/N 10N3844ECanadair F-86E MK.6 · S/N 1482N38453Canadair F-86E MK.6 · S/N 1487N384NDPiper PA-28R-201 · S/N 2844095N390CJTextron 525B · S/N 525B0900N3924MPiper PA-12 · S/N 12-2826N3JCNorth American SNJ-5C · S/N 51875N400MDRaytheon 400A · S/N RK-280N405NDPiper PA-28R-201 · S/N 2844113N41523Piper PA-28-151 · S/N 28-7415250N427YECirrus Design SR22T · S/N 0500N434CDCirrus Design SR22 · S/N 1514N444HCLearjet 31A · S/N 064N4729LPiper PA-28-180 · S/N 28-4053N4746HMooney M20J · S/N 24-0833N501HVBell 206B · S/N 2981
Back to Concord, NC