Greensboro, GA
Registered aircraft · 29
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 = 'GA' 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 = 'GA' 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.
N127KACirrus Design SF50 · S/N 0751N129KACirrus Design SF50 · S/N 0580N194TWCessna T206H · S/N T20609145N21892Piper PA-32RT-300T · S/N 32R-7887237N2622PCirrus Design SR22 · S/N 1821N284MSNorth American T-28B · S/N 138308N3142SCessna 182G · S/N 18255642N3163RWest Garry SPARROW HAWK · S/N SH20040006KSale reported, canceledN3306UCessna 182F · S/N 18254706N3648BPiper AEROSTAR 602P · S/N 62P08668165006N4125EAeronca 11CC · S/N 11CC-34N4449XCessna 182E · S/N 18254138N524SRCirrus Design SR22 · S/N 2313N546KMCirrus Design SR22 · S/N 3262N5606LAmerican AA-1 · S/N AA1-0008N611PSMooney M20J · S/N 24-1278N678ECCirrus Design SR22 · S/N 2881N6958JPiper PA-28-181 · S/N 28-7690441N71659Cessna 182M · S/N 18259708N722ACNorth American AT-6G · S/N 49-3242N728BJCirrus Design SR22 · S/N 4320N759KJCessna 182Q · S/N 18266052N816LMMooney M20R · S/N 29-0250N82VTCirrus Design SR22T · S/N 0956N83MVHall Mark E RV-14A · S/N 140999N84602Piper PA-28-236 · S/N 28-8211014N8755XPiper PA46-500TP · S/N 4697380N8827ZCessna 172H · S/N 17255477N9827UGrumman American Avn. AA-5A · S/N AA5A0227
Back to Greensboro, GA