Bloomington, IL
Registered aircraft · 48
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 = 'IL' AND g.registrant_city = 'BLOOMINGTON' 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 = 'IL' AND g.registrant_city = 'BLOOMINGTON' 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.
N102GMMueller George C MUELLER ONEX · S/N 001N111SRCessna 182R · S/N 18268005N151MPLangley Mark S CHRISTAVIA MK II · S/N MKII-106N1605AAnderson Darin D VANS RV-9A · S/N 92153N1791NCessna 120 · S/N 12035N181WGPiper PA-28-181 · S/N 28-8490069N247MPCessna 560XL · S/N 5605348N283CPEmbraer Executive EMB-505 · S/N 50500870N2864CCessna 170B · S/N 26407Registration pending, pending cancellationN2937RPiper PA-28-161 · S/N 28-7916560N301ZNDJI AGRAS T50 · S/N 63YBLAM002003KN3109CBeech A36 · S/N E-2400N313ACPiper PA-28-161 · S/N 28-7816013N31NMMooney M20J · S/N 24-1334N336RVThorall Daniel E VANS RV6 · S/N 60199N3380NPiper J3C-65 · S/N 22580N3400VCessna 150M · S/N 15076490N3998VCessna 170 · S/N 18317N4149TPiper PA-28-181 · S/N 2843192N419CMN419cm VANS RV10 · S/N 43003N426HCCrisman Harry L ONEX · S/N ONX0103N428CDCirrus Design SR20 · S/N 11359N4350HMooney M20J · S/N 24-0716N451XPiper PA-28-236 · S/N 28-7911129N452Chace Stephen B ACRO SPORT II · S/N 632N4641FPiper PA-28R-200 · S/N 28R-7635431N4698TLockheed T-33A · S/N 9461N46PTPiper PA 46-350P · S/N 4622108N47681Piper PA-28R-201T · S/N 28R-7703421N521BACirrus Design SR20 · S/N 1614N52574Boeing A75N1(PT17) · S/N 75-4948N53580Piper PA-28R-201 · S/N 2844087N595AGTextron 680A · S/N 680A0169N6187HPiper J3C-65 · S/N 19357N6272XAero Commander 680-F · S/N 680F-1159-83N6882JPiper PA-28-151 · S/N 28-7615386N70824Champion 7EC · S/N 7EC-377N750FTThomas Frederick III 750 STOL · S/N 001N755AGMason Harris Griff CHALLENGER II · S/N CH2-0403-2316N8122ZPiper PA-28-236 · S/N 28-8011033N8145ACessna 170B · S/N 20997N8332HPiper PA-28-181 · S/N 28-8190158N8378GCessna 421C · S/N 421C0310N83DPPenning Shawn P VELOCITY FXD GR STD · S/N DMO 187N854LBDJI AGRAS T40 · S/N 64TBK78001004RN900SCessna 310B · S/N 35742N991VTPiper PA-28R-201 · S/N 28R-7837267N99TWThompson James VENTURE · S/N V110PN
Back to Bloomington, IL