Xenia, OH
Registered aircraft · 106
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 = 'OH' AND g.registrant_city = 'XENIA' 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 = 'OH' AND g.registrant_city = 'XENIA' 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.
N101DJAllen VARIEZE · S/N 101N110FLCirrus Design SR22 · S/N 2813N124XXDyer Albert NIEUPORT C-1 · S/N 82856N128AVPiper PA-28 · S/N 28-8516007N143WMVans RV-12 · S/N 120241N14DLLind David L LONG EZ · S/N 1840LFirst renewal noticeN155DRReasoner Donald J RV-6 VANS ACFT INC · S/N 20021N15EVEvolution REVO · S/N 000596N17324Piper PA-28-161 · S/N 287916050N1946HPiper PA-28-161 · S/N 28-7716067N200JEPiper PA 46-350P · S/N 4636501N20368Cessna 172M · S/N 17261230N207PACessna T207 · S/N 20700162N21RGCessna T207 · S/N 20700066N2202PPiper PA-23 · S/N 23-812N229TMRichards Edmond A COZY MARK IV · S/N 088N2412APiper PA-20-135 · S/N 20-924N24CGreat Lakes 2T-1A-2 · S/N 1011N25179Johnson-Mahan BD-4 · S/N 531N2553YPiper PA-28-161 · S/N 28-8516079N255AADJI MAVIC 2 PRO · S/N 163DFBM001TNNJN2565MPiper PA-28-181 · S/N 28-7890257N257AADJI MATRICE 300 RTK · S/N 1ZNBK5900C00BHN2587FChampion 7ECA · S/N 218N258AADJI MAVIC 2 PRO · S/N 163DFBM001QJ54N262AAParrot ANAFI · S/N PS728000BA8H081234N263MAAmerican Champion 8KCAB · S/N 968-2004N263SRCirrus Design SR22 · S/N 2512N2719DCessna 170B · S/N 25261First renewal noticeN30438Gossett Daniel D CHALLENGER II · S/N CH2 1102 B 2279N3079KHead Balloons AX7-77 · S/N 277N3174QCessna 182K · S/N 18258174N3247FMooney M20E · S/N 670040N33424Piper PA-28-151 · S/N 28-7515337N3366GDJI MAVIC 3 PRO · S/N 1581F67QE238G00A00HQN336QGDJI FPV · S/N 37QBJ6PBD102NKN337KGDJI FPV · S/N 37QBJ5WBD102KJN3393CBeech F35 · S/N D-4060N409RVMosher Philip H VANS RV9A · S/N 91388N42787Piper PA-28-151 · S/N 28-7415400N4320DWimer David L QUICKSILVER MX II · S/N 244N4328EAeronca 7AC · S/N 7AC-7181N4385WPiper PA-28-161 · S/N 28-8516002N438CDCirrus Design SR22 · S/N 1404N4503PCameron Balloons Z-70 · S/N 6320N473BCCirrus Design SR22 · S/N 1658N47RVAyers James E RV-3 · S/N 50N49CBCessna 337G · S/N 33701551N5029QCessna 310N · S/N 310N-0129N5060VCirrus Design SR22 · S/N 0829
Back to Xenia, OH