Greensboro, NC
Registered aircraft · 183
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 = 'GREENSBORO' 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 = 'GREENSBORO' 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.
N1034EBellanca 7ECA · S/N 1205-77N1075LLake LA-4-200 · S/N 668N1099Textron 525 · S/N 525-1028N1134DCessna 182T · S/N 18281605N1136PRaytheon A36 · S/N E-3044N1176EBellanca 7GCBC · S/N 988-77N118TRTextron 680A · S/N 680A0452N1225CPiper PA-22-135 · S/N 22-1028N1307Beech 95-B55 · S/N TC-1307N13106Cessna LC41-550FG · S/N 411106N1335BDodson Jerome R MONG SPORT MS-1 · S/N 1N164BBCirrus Design SR22 · S/N 1128N186TATextron 182T · S/N 18283030N1914FCessna A150M · S/N 15064970N19693Taylorcraft A · S/N 300N19JDBalloon Works FIREFLY 7 · S/N 709N19JRCessna 177RG · S/N 177RG-0314N19KBHawker Beechcraft HAWKER 900XP · S/N HA0059N19THonda HA-420 · S/N 42000294N211SVCessna 340A · S/N 340A1000N222JWBeech F33A · S/N CE-1401N223PFPipistrel Italia S R L ALPHA TRAINER · S/N 1002 AT 912 LSAN2257DCessna 170B · S/N 20409N232MECessna 182S · S/N 18280749N233CXHonda HA-420 · S/N 42000270N233EHDassault FALCON 2000 · S/N 144N23534Beech F33A · S/N CE-751N2357NRaytheon A36 · S/N E-3157N237MPCessna 525A · S/N 525A0179N238CGHonda HA-420 · S/N 42000274N23986Beech C23 · S/N M-1910N253RLBeech A36TC · S/N EA-131N26276Grumman American Avn. AA-5A · S/N AA5A0501N263AMAircraft Mfg & Development CH 2000 · S/N 20-1049N26CGTextron B200GT · S/N BY-439N2805RSocata TB21TC · S/N 1138N2872QCessna 172L · S/N 17259872N2878QCessna 172L · S/N 17259878N2885MPiper PA-28-181 · S/N 28-7990526N292SAHonda HA-420 · S/N 42000292N296CXHonda HA-420 · S/N 42000227N300ETHonda HA-420 · S/N 42000300N300JWTextron 525B · S/N 525B0695N3015BCessna 195 · S/N 7898N303LTHonda HA-420 · S/N 42000303N30TMHonda HA-420 · S/N 42000302N3114VBeech 35 · S/N D-536N3166JBalloon Works FIREFLY 7-15 · S/N F71000N319HJHonda HA-420 · S/N 42000065N321BVWilliam D Vinson JR VANS RV-7 · S/N 74171
Back to Greensboro, NC