Des Moines, IA
Registered aircraft · 108
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 = 'DES MOINES' 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 = 'DES MOINES' 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.
N100CCCessna 425 · S/N 425-0170N1080QDJI AGRAS T40 · S/N 64TBK8H00100Q4N111VRPiaggio P180 · S/N 1006N121LMPiper PA-28-181 · S/N 2881529N1330QDJI AGRAS T40 · S/N 64TBK8L00100VTN158ECLearjet 45 · S/N 186N1599APiper PA-20 · S/N 20-841N171SPCessna 182T · S/N 18281977N1906XCessna 182H · S/N 18256006N205HNCessna 210-5(205) · S/N 205-0440N2070GCessna 182A · S/N 51370N2078LCameron Balloons US N-65 · S/N 5440N215TLLockard Theodore E JR RV-10 · S/N 40370N220TGPiper PA-34-220T · S/N 3449265N2211BSmith VOLKSPLANE · S/N MS-1N2226RCessna T210H · S/N T210-0376N2231ECessna 182T · S/N 18281924N227SPCirrus Design SR22 · S/N 5050N231SPCessna 182T · S/N 18282299N24YCPiper PA-23-250 · S/N 27-4551N250DFPiper PA 46-350P · S/N 4636878N2543RCessna 182K · S/N 18258243N2549UFisher Flying Products AVENGER V · S/N A0174N255PGPiper PA-46-701TP · S/N 46020007Sale reportedN26PKBellanca 7ECA · S/N 1041-74N2704PPiper PA-22 · S/N 22-3010N30278Cessna 172M · S/N 17264133N30GXTextron 525B · S/N 525B0594N3210YCessna 182E · S/N 18254210N3279HBalloon Works FIREFLY 7-15 · S/N F71007N3280RPiper PA-28R-180 · S/N 28R-31260N3321CBeech A36 · S/N E-1261N33642Piper PA-28R-200 · S/N 28R-7535166N33EECessna 182M · S/N 18259998N34068Taylorcraft BCS12-65 · S/N 2932N347ACAmerican Champion 7ECA · S/N 1371-98N34MJPilatus PC-12/47E · S/N 1856N3611TTyler Thompson BT1 · S/N BT-01N364PPXag P100 PRO · S/N 1863FPEG8219348RH720N3883TPiper PA-28R-180 · S/N 28R-30210N388ABCentral America Consultantsllc EPIC LT · S/N 017N40967Piper PA-28R-200 · S/N 28R-7435146N428BLCessna 182H · S/N 18256552N432LWCessna 525B · S/N 525B0003N45519Luscombe 8A · S/N 2046N4584VBeech 35 · S/N D-1052N462JSTextron 208B · S/N 208B5817N4636PPiper PA-23-250 · S/N 27-155N494LPPipistrel D O O ALPHA TRAINER · S/N 1136 AT 912 LSAN495PMPiper PA 46-350P · S/N 4636871
Back to Des Moines, IA