Harrison, AR
Registered aircraft · 47
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 = 'AR' AND g.registrant_city = 'HARRISON' 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 = 'AR' AND g.registrant_city = 'HARRISON' 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.
N1013KLuscombe 8A · S/N 3740N103CHHubbart Clyde V CHALLENGER II CWS · S/N CH2-1296-CW-1543N1477QEnstrom Helicopter 280FX · S/N 2138N17660Beech 58 · S/N TH-810N1795Flug & Fahrzeugwerke FFA HBV-DIAMANT 16.5 · S/N 025N183SVAlexandria 17-30A · S/N 05-301031N24518Cessna T206H · S/N T20608236N262CFCrabtree Damon L RV-6 · S/N 20677N276BALet L-23 SUPER BLANIK · S/N 948115N27LEBellanca 17-30A · S/N 00-301030N281SVBellanca 17-30A · S/N 00-301029N284SVBellanca 17-30A · S/N 99-301028N30151Cessna 177 · S/N 17701081N3056LCessna 310J · S/N 310J0056N3133RCessna 182L · S/N 18258533N313GHHutcheson Galen W DEMON-ZELLE · S/N 001N3182HDJI AGRAS T50 · S/N 1581F6BUB23AU00137PCN3184ADJI AGRAS T50 · S/N 1851F6BUB234200103Z2N31CFLarry K Fowler RV-6A · S/N 23631N3462XMooney M20C · S/N 3414N38CEBeech 58 · S/N TH-116N393AWAero Commander DARTER 100/150 · S/N 252N39WFAero Vodochody L-39 · S/N 232218N39WWBurkhart Grob Flugzeugbau SPEED ASTIR II · S/N 4019N40MGBeech 95 · S/N TD-293N4137MRobinson Helicopter R44 II · S/N 12115N4180JPiper PA-28-140 · S/N 28-22518N4510CCessna 170B · S/N 25454N4964YPiper PA-25-235 · S/N 25-4676N5072MTaylorcraft BC12-D · S/N 10372N5535NCessna 182R · S/N 18267777N5763FPiper PA-28-140 · S/N 28-25066N584MJBeech 58 · S/N TH-1512N5884JBeech 95-B55 (T42A) · S/N TC-926N58RHBeech 58 · S/N TH-362N594DSBeech 58P · S/N TJ-318N62ANavion NAVION B · S/N NAV-4-2347BN75806Cessna 172N · S/N 17267965N76985Cessna 140 · S/N 11431N86925Bellanca 14-13 · S/N 1287N90179Cessna 140 · S/N 9244N9212ACessna 170A · S/N 18973N931MWDJI AGRAS T30 · S/N 527BJ5R001002NN933EQDJI AGRAS T30 · S/N 527BJ8Q001000KN94842Forney E · S/N 4956N964HBBeech S35 · S/N D-7629N992CSCessna 550 · S/N 550-0363
Back to Harrison, AR