Greenwood, IN
Registered aircraft · 54
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 = 'IN' 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 = 'IN' 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.
N1085FCessna 172N · S/N 17272951Sale reported, canceledN114KSGulfstream Aerospace G-IV · S/N 1012N1159FCessna 172G · S/N 17254754N1313EAeronca 7AC · S/N 7AC-4874N193SPCessna 172P · S/N 172-76346N200RFBeech C23 · S/N M-1457N2100EBeech A36 · S/N E-290N223JMCessna T182T · S/N T18208484N24KCessna 210 · S/N 57265N26248Grumman American Avn. AA-5A · S/N AA5A0483N26266Grumman American Avn. AA-5A · S/N AA5A0496N271SPCessna 182S · S/N 18280911N283CBBlack Charles B RV-8 · S/N 83047N2997GPitts SPECIAL · S/N BM-01N30124Waco UPF-7 · S/N 5521N317BFPiper PA-28-181 · S/N 28-7990428N3338RCessna R182 · S/N R18200339N36536Piper PA-34-200T · S/N 34-7870341N3769VCessna 150M · S/N 15076615N3897XAero Commander 100 · S/N 134Registration pendingN40EXCrafting Cubs CCK-2000 · S/N CCK-2000-0048N41988Grumman G-44A · S/N 1419N43661Piper PA-28-151 · S/N 28-7415554N45EGDassault FALCON 2000 · S/N 27N4685Bede BD-4 · S/N 800N4864GCessna 172N · S/N 17273411N4893GCessna 172N · S/N 17273440N525ABFlight Design CTSW · S/N 06-10-04N5346DCessna 172N · S/N 17272534N541SADiamond Aircraft Ind DA 40 NG · S/N 40.NC299N5536ECessna 172N · S/N 17271885N5870SBeech 35-C33 · S/N CD-832N6281MStinson 108-3 · S/N 108-4281N6355KCessna 150M · S/N 15077661N6392YCessna 172M · S/N 17264795N64240Cessna 172M · S/N 17265114N646WTEclipse EA500 · S/N 000225N6581GCessna 150L · S/N 15072081N6595GCessna 172N · S/N 17273609N6689MUniversal Stinson 108-3 · S/N 108-4689N721ARTextron T182T · S/N T18209147N737ZJCessna 172N · S/N 17269799N7611WPiper PA-28-180 · S/N 28-1571N7829TCessna 172A · S/N 47429N8104RBeech 95-B55 (T42A) · S/N TC-1259N81388Grumman American Avn. AA-5B · S/N AA5B0524N8260QBoeing A75N1(PT17) · S/N IA-65BS01N8271GCessna 177RG · S/N 177RG0171N8539EChampion 7FC · S/N 7FC-345N8938JPiper PA-28-180 · S/N 28-2955
Back to Greenwood, IN