Greenwood, MS
Registered aircraft · 81
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 = 'MS' AND g.registrant_city = 'GREENWOOD' 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 = 'MS' AND g.registrant_city = 'GREENWOOD' 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.
N1090GGauger Gary L ROTORWAY EXEC 90 · S/N 5013N128EHRobinson Helicopter R44 · S/N 1305N151JSAmerican Champion 8KCAB · S/N 738-94N176JRBeech E-90 · S/N LW-115N1771MCessna 182P · S/N 18264433N179PTChance Vought F4U-5 · S/N 122179N182GWCessna 182L · S/N 18259166N185ELCessna A185E · S/N 18501884N1962MStinson L-5E · S/N 3851N204FGlasflugel HORNET · S/N 52N222UWBeech A36TC · S/N EA-49N22KDNorth American AT-6C · S/N 88-13072N2359KBalony Kubicek Spol Sro BB30D · S/N 1044N2689DCessna 414A · S/N 414A0401Registration pendingN2815RCessna 182K · S/N 18258415N2828EAeronca 7AC · S/N 7AC-6411N290FCCessna 182H · S/N 18256135Registration pendingN3028FLindstrand Balloons 90A · S/N 5110N3070NAir Tractor AT-602 · S/N 602-1250N3075DAir Tractor AT-502B · S/N 502B-3016N309MTDJI AGRAS T50 · S/N 1581F6BUB235V00100A8N31015Head Balloons AX7-77 · S/N 278N310WHCessna 310R · S/N 310R0074N3204GNorth American SNJ-5 · S/N 90952N3455LHawker Beechcraft B200GT · S/N BY-55N3581URaven Industries RALLY RX7 · S/N RX7-3221N3730WPiper PA-32-260 · S/N 32-644N374LSFlight Design CTLS · S/N F-11-08-05N39880Bellanca 17-30A · S/N 73-30551N41258Beech 56TC · S/N TG-25N4202KRyan NAVION A · S/N NAV-4-1202N4217WAir Tractor AT-602 · S/N 602-1180N425TPCessna 425 · S/N 425-0213N436ACAmerican Champion 8GCBC · S/N 411-2000N450VDDJI AGRAS T50 · S/N 1581F6BUB233J00101LEN450WDDJI AGRAS T50 · S/N 1581F6BUB235T0010032N458JTXag P150 · S/N 1863FPEG8223508N0U15N458KTXag P150 · S/N 1863FPEG82235086U92FN467SEBalony Kubicek Spol Sro BB40Z · S/N 987N4996HNorth American T-6G · S/N 49-3320AN5008JCessna 310R · S/N 310R0132N5207KNavion NAVION A · S/N NAV-4-2107N521STCessna 305C (0-1E) · S/N 24584N522MABell 206B · S/N 2986N528EDavid M Edwards JR JUST ACFT LLC HIGHLA · S/N JA528-09-18N5508SCessna 188 · S/N 188-0008N555KABeech D95A · S/N TD-707N567ETBeech 95-B55 (T42A) · S/N TC-1866N57560Piper J3C-65 · S/N 10146N577TBCreecy Jc/American Dragon Aero CHALLENGER II · S/N CH2-1005-2692
Back to Greenwood, MS