Conway, AR
Registered aircraft · 116
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 = 'CONWAY' 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 = 'CONWAY' 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.
N110TUCostruzioni Aeronautiche Tecna P2008 · S/N 110N11356Cessna 150L · S/N 15075348N115EACessna 340A · S/N 340A0484N1196VBeech D17S · S/N 6703N12HGPitts Special S-1C · S/N 1N13127Cessna 172M · S/N 17262517N150BLCessna 560XL · S/N 560-5143N1520RGrumman American Avn. AA-5B · S/N AA5B-0020N159LCAmerican Legend AL3 · S/N AL-1159N15LCAmerican Legend AL3 · S/N AL-1150N15XLBeech 95-B55 (T42A) · S/N TC-2048N1606RGrumman American Avn. AA-1B · S/N AA1B-0606N172LCCessna 172M · S/N 17263219N19111Cessna 150L · S/N 15074176N191CFBalony Kubicek Spol Sro BB30Z · S/N 1802N1948BCessna 177RG · S/N 177RG0564N194JRAdams William E JR CHALLENGER II · S/N CH2-1105-2696N20349Taylor-Young "A" · S/N 415N213JJWaco Classic YMF-F5C · S/N F5C109N216HPGrossl Cameron L EAGLE II · S/N 001N216TEJohnson Marion Frank RV-6 · S/N 24504N21820Piper J3C-65 · S/N 2612N2184TPiper PA-28-180 · S/N 28-7205028N223RGAeronca 7AC · S/N 7AC-1464Sale reportedN2355TRaytheon A36 · S/N E-3195N2359WBalony Kubicek Spol Sro BB30XR · S/N 1113Registration pendingN274AMBeech C24R · S/N MC-567N2762YBeech 95 · S/N TD-129N2803MRaytheon A36 · S/N E-3463N2812LCessna 172H · S/N 17256012N28684Grumman American Avn. AA-5B · S/N AA5B0756N2885QCessna 172L · S/N 17259885N2939ABeech E33A · S/N CE-286N30ERTrevor Chadwick F1 EVO ROCKET · S/N T-169N310MSCessna 310R · S/N 310R1623N313RVBauer Frederick Ronald JR VANS RV3B · S/N 11366N3145WBeech A36 · S/N E-505N32647Piper J3C-65 · S/N 5516N327ZFJohn Ferguson GT-VX1 · S/N VX1-014N3367Beech 95-C55 · S/N TE-146N340AGCessna 340 · S/N 340-0205N3446XMooney M20C · S/N 3407N346BGBeech V35B · S/N D9494N35311Piper J3C-65 · S/N 6277N35MJDolloph ACEY DEUCY P70 · S/N 035N3729DBeech 77 · S/N WA-141N3731SCessna 172E · S/N 17250931N373LMBeech D55 · S/N TE-740N37841Culver LFA · S/N 345N37CRRomano Charles RV-6 · S/N 20108
Back to Conway, AR