# Registered aircraft: Burlington, ND

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

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

- [N301SP](https://openairdocs.org/aircraft/N301SP.md): Mooney M20J · S/N 24-1074 · Beyond Air Llp
- [N34926](https://openairdocs.org/aircraft/N34926.md): Interstate S-1A · S/N 121 · Built 1941 · Pietsch Kent D
- [N37309](https://openairdocs.org/aircraft/N37309.md): Interstate S-1A · S/N 152 · Built 1941 · Pietsch Kent D
- [N37361](https://openairdocs.org/aircraft/N37361.md): Interstate S-1A-65F · S/N 204 · Built 1941 · Pietsch Kent D
- [N37403](https://openairdocs.org/aircraft/N37403.md): Interstate S-1A · S/N 246 · Built 1942 · Pietsch Kent D
- [N37410](https://openairdocs.org/aircraft/N37410.md): Interstate S-1A · S/N 312 · Pietsch Kent D
- [N37428](https://openairdocs.org/aircraft/N37428.md): Interstate S-1A · S/N 273 · Built 1942 · Pietsch Kent D
- [N3896M](https://openairdocs.org/aircraft/N3896M.md): Piper PA-12 · S/N 12-2796 · Built 1947 · Behm Jerome William
- [N431KP](https://openairdocs.org/aircraft/N431KP.md): Meggers Roger D STARDUSTER SA300X · S/N SA2281X · Built 2020 · Pietsch Kent D
- [N4600E](https://openairdocs.org/aircraft/N4600E.md): Champion 7CCM · S/N 7CCM-171 · Built 1949 · Pietsch Kent D
- [N723MA](https://openairdocs.org/aircraft/N723MA.md): Cirrus Design SR22T · S/N 8901 · Built 2022 · Wagons West Management LLC
- [N7441S](https://openairdocs.org/aircraft/N7441S.md): Smith AEROSTAR 601 · S/N 61-0024 · Built 1969 · Kp Stunt Productions Inc
- [N7889P](https://openairdocs.org/aircraft/N7889P.md): Mooney M20C · S/N 2403 · Built 1963 · Walker Zachary R
- [N861M](https://openairdocs.org/aircraft/N861M.md): Waco BSO · S/N 3006 · Built 1929 · Pietsch Kent D
- [N87021](https://openairdocs.org/aircraft/N87021.md): Bellanca 7ECA · S/N 1033-74 · Built 1974 · Haugen Delos L
- [N900ZP](https://openairdocs.org/aircraft/N900ZP.md): Socata TBM 700 · S/N 1062 · Built 2015 · Tripp Aviation LLC
- [N915H](https://openairdocs.org/aircraft/N915H.md): Waco ATO · S/N A-125 · Pietsch Kent D
- [N927WT](https://openairdocs.org/aircraft/N927WT.md): Champion 7ECA · S/N 438 · Built 1966 · Haugen Delos 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 = 'ND' AND g.registrant_city = 'BURLINGTON'
ORDER BY g.n_number
```

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