# Registered aircraft: Columbia, IL

A list on [Columbia, IL](https://openairdocs.org/faa-place/IL/Columbia.md).

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

- [N1002M](https://openairdocs.org/aircraft/N1002M.md): Cessna 172L · S/N 17259402 · Built 1970 · Schuler Mark E
- [N123AC](https://openairdocs.org/aircraft/N123AC.md): Cessna 172D · S/N 17249624 · Built 1962 · Aerocareers Nfp
- [N142LC](https://openairdocs.org/aircraft/N142LC.md): Pacific Aviation Composites US LC 40-550FG · S/N 40003 · Built 1998 · Aerocareers Nfp
- [N250AL](https://openairdocs.org/aircraft/N250AL.md): Embraer Executive EMB-505 · S/N 50500595 · Built 2021 · Trs Transportation Inc
- [N257CC](https://openairdocs.org/aircraft/N257CC.md): Cape Copters M16 TANDEM TRAINER · S/N 16224054 · Registration pending · Built 2023
- [N28650](https://openairdocs.org/aircraft/N28650.md): Grumman American Avn. AA-5B · S/N AA5B0723 · Built 1978 · Loseka Tiger LLC
- [N2908E](https://openairdocs.org/aircraft/N2908E.md): Aeronca 7AC · S/N 7AC-6491 · Built 1946 · Bane Alan D
- [N36600](https://openairdocs.org/aircraft/N36600.md): Aeronca 65-CA · S/N C-16991 · Built 1941 · Johnson Anthony L
- [N3809B](https://openairdocs.org/aircraft/N3809B.md): Beech F35 · S/N D-4072 · Built 1955 · N3809b LLC
- [N413EM](https://openairdocs.org/aircraft/N413EM.md): Mooney M20R · S/N 29-0388 · Built 2005 · 413em LLC
- [N4336Q](https://openairdocs.org/aircraft/N4336Q.md): Rans S-6ES COYOTE II · S/N 09021455 · Built 2002 · Schlemmer Aaron W
- [N4760R](https://openairdocs.org/aircraft/N4760R.md): Sackman Randal D SACKMAN SPECIAL · S/N 003 · Built 2003 · Sackman Randal D
- [N525CT](https://openairdocs.org/aircraft/N525CT.md): Cessna 525A · S/N 525A0397 · Built 2008 · Heartland Companies Inc
- [N5504R](https://openairdocs.org/aircraft/N5504R.md): Cessna 172F · S/N 17253075 · Built 1965 · Aerocareers Nfp
- [N581J](https://openairdocs.org/aircraft/N581J.md): Jabiru USA Sport J250-SP · S/N 326 · Built 2006 · Loos Gary
- [N610BM](https://openairdocs.org/aircraft/N610BM.md): Buckeye BREEZE · S/N 16418 · Built 2004 · Mcdaniel Robert L
- [N66CR](https://openairdocs.org/aircraft/N66CR.md): Razer Chester RV-6A · S/N 24197 · Razer Chester R
- [N814BM](https://openairdocs.org/aircraft/N814BM.md): Cessna 172H · S/N 17255216 · Built 1966 · Mcdaniel Robert L
- [N815BB](https://openairdocs.org/aircraft/N815BB.md): Nanchang China CJ-6A · S/N 2951216 · Built 1969 · Schuler Mark E
- [N89052](https://openairdocs.org/aircraft/N89052.md): Cessna 140 · S/N 8056 · Built 1946 · Gateway Tailwheel Club LLC
- [N9446L](https://openairdocs.org/aircraft/N9446L.md): American AA-1A · S/N AA1A-0246 · Built 1971 · Narzinski Daniel
- [N97737](https://openairdocs.org/aircraft/N97737.md): Stinson 108 · S/N 108-737 · Built 1946 · Johnson Anthony L

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 = 'COLUMBIA'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/IL/Columbia/aircraft

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.