# Registered aircraft: Rosenberg, TX

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

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

- [N111BW](https://openairdocs.org/aircraft/N111BW.md): Beech E35 · S/N D-3780 · Built 1954 · Knudsen Kent A
- [N166SS](https://openairdocs.org/aircraft/N166SS.md): Robinson Helicopter R66 · S/N 1332 · Built 2024 · Lane Aviation Inc
- [N2986E](https://openairdocs.org/aircraft/N2986E.md): Cessna 182R · S/N 18268225 · Built 1982 · Ybarguen Johnny C
- [N43183](https://openairdocs.org/aircraft/N43183.md): Piper PA-28R-200 · S/N 28R-7435251 · Built 1974 · Isbell Brian K
- [N4627K](https://openairdocs.org/aircraft/N4627K.md): Cessna P210N · S/N P21000245 · Built 1979 · Isbell Brian
- [N602MS](https://openairdocs.org/aircraft/N602MS.md): Air Tractor AT-602 · S/N 602-1165 · Built 2008 · Lane Aviation Inc
- [N6198H](https://openairdocs.org/aircraft/N6198H.md): Piper PA-23-235 · S/N 25-5419 · Lane Aviation Inc
- [N625LA](https://openairdocs.org/aircraft/N625LA.md): Piper PA-18-150 · S/N 18-8893 · Built 1970 · Lane Aviation Inc
- [N648LA](https://openairdocs.org/aircraft/N648LA.md): Air Tractor AT-502B · S/N 502B-0649 · Built 2002 · Lane Aviation Inc
- [N67XX](https://openairdocs.org/aircraft/N67XX.md): Cub Crafters PA18-150 · S/N 9958CC · Built 2003 · Lane Aviation Inc
- [N7338Q](https://openairdocs.org/aircraft/N7338Q.md): Cessna 182P · S/N 18260978 · Built 1972 · Botts Eugene J
- [N736UT](https://openairdocs.org/aircraft/N736UT.md): Cessna R172K · S/N R1722804 · Built 1977 · Isbell Brian K
- [N782K](https://openairdocs.org/aircraft/N782K.md): Beech 95-B55 (T42A) · S/N TC-924 · Built 1965 · Aaron Daryl G
- [N858LA](https://openairdocs.org/aircraft/N858LA.md): Hawker Beechcraft G58 · S/N TH2230 · Built 2008 · Lane Aviation Inc
- [N861SC](https://openairdocs.org/aircraft/N861SC.md): Raytheon A36 · S/N E3128 · Built 1997 · Spotted Hawk Aviation LLC
- [N8HN](https://openairdocs.org/aircraft/N8HN.md): Piper PA-28R-200 · S/N 28R-7535277 · Built 1975 · Sol Property Group LLC
- [N93PA](https://openairdocs.org/aircraft/N93PA.md): Piper PA-44-180T · S/N 44-8207015 · Built 1982 · Isbell Brian K
- [N98389](https://openairdocs.org/aircraft/N98389.md): Piper PA-28-140 · S/N 28-26207 · Sale reported · Built 1969
- [N992LA](https://openairdocs.org/aircraft/N992LA.md): Raytheon C90GT · S/N LJ-1812 · Built 2007 · Lane Aviation Inc

## 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 = 'TX' AND g.registrant_city = 'ROSENBERG'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/TX/Rosenberg/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.