# Registered aircraft: AD 2001-03-01

A list on [AD 2001-03-01](https://openairdocs.org/ad/2001-03-01.md).

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

- [N1221Q](https://openairdocs.org/aircraft/N1221Q.md): Nonstop Leasing LLC · Elmhurst, IL · Built 2001 · S/N 045
- [N132JC](https://openairdocs.org/aircraft/N132JC.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2001 · S/N 033
- [N143CB](https://openairdocs.org/aircraft/N143CB.md): Garudda LLC · Fort Lauderdale, FL · Built 2001 · S/N 043
- [N213EP](https://openairdocs.org/aircraft/N213EP.md): Jssi Parts LLC · Chicago, IL · Built 2001 · S/N 052
- [N251LB](https://openairdocs.org/aircraft/N251LB.md): Aerotrust Services Corp Trustee · Wilmington, DE · Built 2000 · S/N 024
- [N415PR](https://openairdocs.org/aircraft/N415PR.md): Dlh N415pr LLC · Cortland, NY · Built 2000 · S/N 017
- [N479PR](https://openairdocs.org/aircraft/N479PR.md): Nellie Navigation LLC · Naples, FL · Built 2000 · S/N 008
- [N531MB](https://openairdocs.org/aircraft/N531MB.md): Caleah Acquisitions LLC · Savannah, GA · Built 2001 · S/N 044
- [N54CM](https://openairdocs.org/aircraft/N54CM.md): Gac Wings LLC · Boca Raton, FL · Built 2001 · S/N 042
- [N671BP](https://openairdocs.org/aircraft/N671BP.md): 671bp LLC · Cypress, TX · Built 2000 · S/N 031
- [N672PS](https://openairdocs.org/aircraft/N672PS.md): Fort Stephenson Air LLC · Chattanooga, TN · Built 1999 · S/N 010
- [N777ZR](https://openairdocs.org/aircraft/N777ZR.md): 671bp LLC · Dover, DE · Built 1999 · S/N 007
- [N7FF](https://openairdocs.org/aircraft/N7FF.md): Westwind Air LLC · Champaign, IL · Built 2001 · S/N 038
- [N800PJ](https://openairdocs.org/aircraft/N800PJ.md): Johnson Franklin P Jr DBA · Palo Alto, CA · Built 2000 · S/N 026
- [N812FT](https://openairdocs.org/aircraft/N812FT.md): Bizav Support LLC · Fort Lauderdale, FL · Built 2000 · S/N 019
- [N817VC](https://openairdocs.org/aircraft/N817VC.md): Veteran Airways LLC · Pooler, GA · Built 2000 · S/N 021
- [N866G](https://openairdocs.org/aircraft/N866G.md): Hk Aviation Corp · Wilmington, DE · Built 2000 · S/N 025
- [N8MF](https://openairdocs.org/aircraft/N8MF.md): Mf Air LLC · Wilmington, DE · Built 1999 · S/N 006
- [N929GA](https://openairdocs.org/aircraft/N929GA.md): Madison Air LLC · Salem, OR · Built 2000 · S/N 029

## The whole list in SQL

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

```sql
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2001-03-01')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-03-01')
ORDER BY n_number
```

This list as a web page: https://openairdocs.org/ad/2001-03-01/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.
