Evansville, IN
Registered aircraft · 97
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 = 'EVANSVILLE' 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 = 'EVANSVILLE' 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.
N147RVJules T Mominee RV-7A · S/N 73281N14GZZimmerman Gary GLASIR SUPER 2RG · S/N 2312N14SCSocata TBM 700 · S/N 589N16299Piper PA-28-235 · S/N 28-7310084N1873Embraer Executive EMB-505 · S/N 50500652N212GTRay RV6A · S/N 60248N224JSSchmitt Jim PULSAR · S/N 304N227JCCrabtree John RV-6 · S/N JC-01N233EESchroeder Earl E LANCAIR 235/320 · S/N 1N234PGCirrus Design SR22 · S/N 0935N23ZMAlan L Beers RAVEN-GB1 · S/N 090807N247AJCessna 550 · S/N 550-1006N2562TDestiny Alliant XLT · S/N 4C0595N2576EAeronca 7BCM · S/N 7AC-6159N269RZGarrett TITAN II TORNADO · S/N D96XXXCOHK0200N26YCManley/Munday/Bell SUPER REBEL · S/N SR 275N286REMurphy Ronald E RV-4 · S/N 2369N287PPiper PA-28-140 · S/N 28-24806N28CKCessna 525 · S/N 525-0210N2982LMooney M20F · S/N 670341N300HCCessna T210N · S/N 21064804N30632Cessna 177B · S/N 17701371First renewal noticeN3118XCessna 150F · S/N 15064518N311TNMooney M20TN · S/N 31-0001N32VCessna 340A · S/N 340A0250N3581VCessna 140 · S/N 14850N35916Piper J4E · S/N 4-1445N3595JCessna 150E · S/N 15061295N359SCCzech Aircraft Works Spol Sro SPORTCRUISER · S/N 08SC223N361TACirrus Design SR22 · S/N 3325N369JJCessna 195A · S/N 7510N3913EAeronca 11AC · S/N 11AC-S100N3956PPiper PA-22-150 · S/N 22-3634N4057NMooney M20C · S/N 680027N41618Piper PA-28-151 · S/N 28-7415295N41766Newman George J VANS RV6A · S/N 24012N4256FPiper PA-28-151 · S/N 28-7715011First renewal noticeN453MJJarvis Michael C CGS HAWK SS ARROW · S/N H-SSA-897-R503-TRIN45BBCessna 421C · S/N 421C0661N463RKRepublic RC-3 · S/N 958N468ABRulat Development MOSQUITO XET · S/N MXE1233G13BN471JJohnson Stitts Playboy SA3A · S/N P865N4747PRepublic / Blue Sky P47D-40-RA · S/N 44-90368N4799XCessna 150G · S/N 15064849N47DBeech D17R · S/N 289N4967TPiper PA-28R-200 · S/N 28R-7235164N49KSSchlageter RV8 · S/N 80650N50142Boeing A75N1(PT17) · S/N 75-962N50224Cessna 150H · S/N 15069149N50417Taylorcraft DCO-65 · S/N L-5348
Back to Evansville, IN