Davenport, IA
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 = 'IA' AND g.registrant_city = 'DAVENPORT' 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 = 'IA' AND g.registrant_city = 'DAVENPORT' 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.
N123VHHenson Victor C AWL · S/N 001N128MSVans RV-12 · S/N 120088N1503RGrumman American Avn. AA-5B · S/N AA5B-0003N1692CCessna 180 · S/N 30392N2027Wsk-Pzl Mielec MIG-15 UTI (LIM2) · S/N 1A06027First renewal noticeN21001Cessna 182P · S/N 18261347N214EFAmerican Champion 8KCAB · S/N 1126-2013N2161RCessna 182G · S/N 18255361N2232QPiper PA-28-236 · S/N 28-7911106N223VBCirrus Design SR22T · S/N 2054N22630Taylorcraft BL-65 · S/N 1277N2338HEngineering & Research 415-C · S/N 2963N235LHHefel Lyle L HEFEL RV-8 · S/N 80844N2824QCessna 172L · S/N 17259824N2832Aerostar S A YAK-52 · S/N 866411N301MFAirbus Helicopters Deutschland EC135 P3 · S/N 2109N305MFAirbus Helicopters Deutschland EC135 P3 · S/N 2120N306BDGulfstream Aerospace GV-SP (G550) · S/N 5354N30MYTextron B300 · S/N FL1062N311MFEurocopter Deutschland EC 135 P2+ · S/N 1069N315MFEurocopter Deutschland EC 135 P2+ · S/N 0896N3249Aero Vodochody L29 · S/N 993249N324JPHawker Beechcraft C90GTI · S/N LJ-1921First renewal noticeN38318Piper J3L-65 · S/N 6928N413JBeech 95-B55 (T42A) · S/N TC-831N465KTCarlson Ivan D PULSAR SP100 · S/N 902N4716KCessna 182P · S/N 18263715N50RGHawker Beechcraft B200GT · S/N BY-160N527PMRaytheon 400A · S/N RK-304N556DMBoeing B75N1 · S/N 75-7581N67614Cessna 152 · S/N 15281948N6874ACessna 172 · S/N 28974N6909BPiper PA-22-150 · S/N 22-4184N702DRatliff John B CHALLENGER II · S/N CH2-0104-2421N7094GCessna 172K · S/N 17258794N750VMHawker Beechcraft HAWKER 750 · S/N HB-69N754CAHawker Beechcraft B200 · S/N BB-2013N75662Boeing A75N1 · S/N 75-5621N7720TTalos Drones T60X · S/N 2104F7EZW2567001107VN77589Piper J3C-65 · S/N 22079N8001XArbc Inc DBA Lindstrand 60X · S/N 5807N818TCHowell Mark R RV-8 · S/N 001N8193ZPiper PA-32R-301 · S/N 32R-8013091N8338LCessna 172I · S/N 17256538N858RJerry Coussens LANCAIR IV (4) · S/N 4621N902RYHawker Beechcraft 400A · S/N RK-524N9179TDJI INSPIRE 2 · S/N 09YDH8D0R416X7
Back to Davenport, IA