Dubuque, IA
Registered aircraft · 52
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 = 'DUBUQUE' 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 = 'DUBUQUE' 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.
N1160XPiper PA-28R-200 · S/N 28R-7535261N11720Bellanca 7ECA · S/N 860-72N15643Piper PA-28R-200 · S/N 28R-7335088N216AWilliams Donald E RV6A · S/N 22832N238MCPiper PA-32R-301 · S/N 3213047N244EAEa Vision EA J100 · S/N 85415Registration pending, pending cancellationN271KSpartan C3-120 · S/N 99N287CBTextron 525 · S/N 525-0942N323MGPiper PA-28R-200 · S/N 28R-7635256N3390GWhittman Tailwind JCG · S/N PU109N350MRBurns J Mitchel PIETENPOL AIRCAMPER · S/N 1N35JBeech J35 · S/N D-5699N36129Piper PA-32RT-300 · S/N 32R-7885164N36VJVercammen John A SONERAI II LT · S/N 01552LN387CBTextron 525B · S/N 525B0601N38EBBradford ED ED BRADFORD AIR COMM · S/N EB001N4027YSpirit Engineering SE-1 · S/N 022N414RAEa Vision EA J100 · S/N 85412Registration pending, pending cancellationN4164UCessna 150D · S/N 15060164N429MRCessna 525C · S/N 525C0011N487CBTextron 525 · S/N 525-0878N50087Boeing A75N1(PT17) · S/N 75-1094N533VEWagner Robert VARIEZE · S/N 1533N5367FPiper PA-28-181 · S/N 28-7790100N56AYTextron 525C · S/N 525C0251N579CACommander 114-B · S/N 14579N6003XMooney M20A · S/N 1591N6189LAmerican AA-1 · S/N AA1-0389N619HCMark G Wallace ZENITH · S/N 6-3438N6366TFischer Thomas E RV-6A · S/N 24653N64BTBeech F33A · S/N CE-1152N65981Cessna 150L · S/N 15075756Registration pendingN707HACessna 421C · S/N 421C1044N735YRCessna 182Q · S/N 18265795N744ANVans RV-12IS · S/N 121167N749PGCirrus Design SR22 · S/N 1339N7583SCessna 182Q · S/N 18265232N758MGTextron 680A · S/N 680A0391N761BYCessna T210M · S/N 21062137N799ALBeech 300 · S/N FA-157N82799Champion 7AC · S/N 7AC-1446N8361LCessna 172I · S/N 17256561N854RCBoeing A75N1(PT17) · S/N 75-2230N858MGTextron 680A · S/N 680A0002N85LXTextron 525 · S/N 525-1085N867WCessna 560XL · S/N 560-5601N888VFPiper PA-34-220T · S/N 34-8233073N892MMPiper PA-31-325 · S/N 31-8112029N955DQCharles Weber/Philip Mull RV-10 · S/N 41578N958MGCessna 525 · S/N 525-0805
Back to Dubuque, IA