Bloomington, IN
Registered aircraft · 99
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 = 'IN' 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 = 'IN' 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.
N1096FAdams Balloon Loft A55S · S/N 401N109GXIsrael Aircraft Industries GULFSTREAM 100 · S/N 142N119PTCirrus Design SR22T · S/N 9398N119TLTextron B200GT · S/N BY-276N1228WCameron Balloons US A-180 · S/N 6416N141SDAeropro CZ EUROFOX · S/N 220 07N1520HLindstrand Balloons 90A · S/N 5360N173DKKing Dennis M VELOCITY 173RG ELITE · S/N DM0391N17DTCirrus Design SR22T · S/N 1974N1933MCessna 182P · S/N 18264487N202JTCirrus Design SR22 · S/N 0230N222KGThomas L Vanderheyden RV-7 · S/N 73555N2390NCessna 140 · S/N 12639N2435CCessna 182S · S/N 18280644N26052Grumman American Avn. AA-5A · S/N AA5A0407Registration pendingN275DFFrye Dale L STRDSTR TOO SA 300 · S/N 2518N29539Cessna 177 · S/N 17700950N2980YCessna 182E · S/N 18253980N299XAeropro CZ S R O A240 · S/N 32611Registration pendingN300PMCessna 310R · S/N 310R1382N3061WPiper PA-32-300 · S/N 32-7940079N30FBCessna 414A · S/N 414A0067N318WTCirrus Design SR22 · S/N 0474N370WCameron Balloons U S N-133 · S/N 6342N38430Piper PA-32R-300 · S/N 32R-7780426N4002BAdams Balloon Loft A-60S · S/N 405N4002PAdams Balloon Loft A-60S · S/N 403N400BACessna LC41-550FG · S/N 411054N4019KArbc Inc DBA Lindstrand 105A · S/N 5716N4022KAdams Balloon A B · S/N 127N418ASocata TBM 700 · S/N 292N427ATCirrus Design SR22 · S/N 0954N4284TPiper PA-28-180 · S/N 28-7205130N4476WBeech 95-B55 (T42A) · S/N TC-1809N45135Gulfstream American AA-5B · S/N AA5B0829N48UMSocata TBM-700 C2 · S/N 299N498SPCessna 172S · S/N 172S8039N500MBombardier CL-600-2B16 · S/N 5480N506PCSocata TAMPICO TB 9C · S/N 1465N518PRRichardson Andrew P RICHARDSON-SHIP 110 · S/N 004N522LBLindstrand Balloons 69A · S/N 127N5356CCessna 140A · S/N 15487N53LRRobinson Helicopter R44 II · S/N 12411N5457ECessna 172N · S/N 17271873N560WLindstrand Balloons 105A · S/N 5250N5659ECessna 150 · S/N 17159N5677VPiper PA-32R-300 · S/N 32R-7780359N6040SCessna T182T · S/N T18208589N6045PPiper PA-24-250 · S/N 24-1141N604GWBombardier CL-600-2B16 · S/N 5424
Back to Bloomington, IN