# Registered aircraft: Crawfordville, FL

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

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

- [N152MY](https://openairdocs.org/aircraft/N152MY.md): Young Mark A ROTORWAY EXEC · S/N MY1 · Built 1987 · Newberry Ernest B Jr
- [N15LD](https://openairdocs.org/aircraft/N15LD.md): Davison RAND KR-2 · S/N 95870 · Built 1975 · Davison Leo C
- [N19237](https://openairdocs.org/aircraft/N19237.md): Cessna 150L · S/N 15074262 · Built 1972 · Peavy Tracy R
- [N200KV](https://openairdocs.org/aircraft/N200KV.md): Bell 47G-2 · S/N 2258 · Built 1960 · Peavy Magnus Delacy IV
- [N2062L](https://openairdocs.org/aircraft/N2062L.md): Beech C23 · S/N M-1863 · Built 1976 · Johnson Robert A
- [N35638](https://openairdocs.org/aircraft/N35638.md): Cessna 172I · S/N 17256879 · Built 1968 · Newberry Ernest B Jr
- [N399AG](https://openairdocs.org/aircraft/N399AG.md): Whiting Harry H AVENTURA II · S/N A-P0059 · Graffeo Alexander S
- [N4260R](https://openairdocs.org/aircraft/N4260R.md): Piper PA-32-300 · S/N 32-40634 · Built 1969 · Colin Irons Diving And Pool Service
- [N42651](https://openairdocs.org/aircraft/N42651.md): Piper J3C-65 · S/N 14942 · Built 1945 · Johnson Robert A
- [N50181](https://openairdocs.org/aircraft/N50181.md): Cessna 150H · S/N 15069113 · Built 1968 · Debelius Enemark Peter C
- [N52237](https://openairdocs.org/aircraft/N52237.md): Boeing A75N1(PT17) · S/N 75-4599 · Built 1940 · Peavy Delacy
- [N54123](https://openairdocs.org/aircraft/N54123.md): Mullis William D HIGHLANDER · S/N JA251-10-11 · Walker Clen A
- [N72153](https://openairdocs.org/aircraft/N72153.md): Cessna 140 · S/N 9320 · Built 1946 · Carnley Billy T
- [N7342A](https://openairdocs.org/aircraft/N7342A.md): Cessna 172 · S/N 29442 · Built 1957 · Newberry Ernest B Jr
- [N8183L](https://openairdocs.org/aircraft/N8183L.md): Piper J3C-65 · S/N 22492 · Peavy Magnus Delacy IV
- [N8210M](https://openairdocs.org/aircraft/N8210M.md): Cessna 210K · S/N 21059210 · Built 1969 · Peavy Magnus Delacy IV
- [N8512A](https://openairdocs.org/aircraft/N8512A.md): Compton Leonard M JUNIOR ACE · S/N 1 · Built 1996 · Kiper Ted B
- [N8987T](https://openairdocs.org/aircraft/N8987T.md): Cessna 182C · S/N 52887 · Built 1960 · Peavy Magnus Delacy IV
- [N91366](https://openairdocs.org/aircraft/N91366.md): Davison BEE · S/N 001 · Built 1978 · Davison Leo C
- [N94041](https://openairdocs.org/aircraft/N94041.md): Ercoupe 415-C · S/N 1364 · Built 1946 · Robinson Randall 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 = 'FL' AND g.registrant_city = 'CRAWFORDVILLE'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/FL/Crawfordville/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
