# Registered aircraft: AD 2004-05-21 A list on [AD 2004-05-21](https://openairdocs.org/ad/2004-05-21.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. Page 1 of 2 · 68 aircraft - [N193SJ](https://openairdocs.org/aircraft/N193SJ.md): Frontera Flight Holdings Inc · Dover, DE · S/N 193 - [N330EN](https://openairdocs.org/aircraft/N330EN.md): Universal Hydrogen Co · Hawthorne, CA · Built 1991 · S/N 274 - [N349PH](https://openairdocs.org/aircraft/N349PH.md): Bam Leasing LLC · California, MD · Built 1997 · S/N 486 - [N351PH](https://openairdocs.org/aircraft/N351PH.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 1997 · S/N 490 - [N359PH](https://openairdocs.org/aircraft/N359PH.md): Bighorn Airways Inc · Sheridan, WY · Built 1998 · S/N 514 - [N360PH](https://openairdocs.org/aircraft/N360PH.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 1998 · S/N 515 - [N363PH](https://openairdocs.org/aircraft/N363PH.md): Wells Fargo Trust Co Na Trustee · Columbia, MD · Built 1998 · S/N 520 - [N365PH](https://openairdocs.org/aircraft/N365PH.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 1998 · S/N 526 - [N367PH](https://openairdocs.org/aircraft/N367PH.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 1998 · S/N 511 - [N406AV](https://openairdocs.org/aircraft/N406AV.md): Berry Aviation Inc · San Marcos, TX · Built 1996 · S/N 460 - [N428MS](https://openairdocs.org/aircraft/N428MS.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 1996 · S/N 428 - [N436YV](https://openairdocs.org/aircraft/N436YV.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 436 - [N437YV](https://openairdocs.org/aircraft/N437YV.md): Wells Fargo Trust Co Na Trustee · Columbia, MD · S/N 437 - [N444YV](https://openairdocs.org/aircraft/N444YV.md): Wells Fargo Trust Co Na Trustee · Salt Lake City, UT · S/N 444 - [N449YV](https://openairdocs.org/aircraft/N449YV.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 1996 · S/N 449 - [N475SN](https://openairdocs.org/aircraft/N475SN.md): Sierra Nevada Company LLC · Sparks, NV · S/N 475 - [N480AV](https://openairdocs.org/aircraft/N480AV.md): Berry Aviation Inc · San Marcos, TX · Built 1997 · S/N 484 - [N492BA](https://openairdocs.org/aircraft/N492BA.md): Berry Aviation Inc · San Marcos, TX · Built 1997 · S/N 492 - [N539AR](https://openairdocs.org/aircraft/N539AR.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 539 - [N541AV](https://openairdocs.org/aircraft/N541AV.md): Sierra Nevada Company LLC · Sparks, NV · Built 2000 · S/N 541 - [N556PM](https://openairdocs.org/aircraft/N556PM.md): 645 Aeronautical Systems Group (Aesg) · Wpafb, OH · Built 1996 · S/N 413 - [N560WK](https://openairdocs.org/aircraft/N560WK.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 560 - [N563AW](https://openairdocs.org/aircraft/N563AW.md): US Department Of State · Melbourne, FL · S/N 563 - [N567WK](https://openairdocs.org/aircraft/N567WK.md): US Dept Of State · Melbourne, FL · S/N 567 - [N568AW](https://openairdocs.org/aircraft/N568AW.md): US Department Of State · Melbourne, FL · S/N 568 - [N569AW](https://openairdocs.org/aircraft/N569AW.md): US Department Of State · Melbourne, FL · S/N 569 - [N570AW](https://openairdocs.org/aircraft/N570AW.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 570 - [N579HC](https://openairdocs.org/aircraft/N579HC.md): Rangeflyers Inc Trustee · Wichita, KS · S/N 579 - [N580AR](https://openairdocs.org/aircraft/N580AR.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 580 - [N589AW](https://openairdocs.org/aircraft/N589AW.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 589 - [N599AR](https://openairdocs.org/aircraft/N599AR.md): Bank Of Utah Trustee · Salt Lake City, UT · S/N 599 - [N619GN](https://openairdocs.org/aircraft/N619GN.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 1995 · S/N 415 - [N637CC](https://openairdocs.org/aircraft/N637CC.md): Bank To Utah Trustee · Salt Lake City, UT · S/N 637 - [N646CC](https://openairdocs.org/aircraft/N646CC.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2007 · S/N 646 - [N649CC](https://openairdocs.org/aircraft/N649CC.md): Bank Of Utah Trustee · Salt Lake City, UT · Built 2007 · S/N 649 - [N706XT](https://openairdocs.org/aircraft/N706XT.md): Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT · Built 1997 · S/N 505 - [N800AW](https://openairdocs.org/aircraft/N800AW.md): US Department Of State · Melbourne, FL · S/N 573 - [N801MR](https://openairdocs.org/aircraft/N801MR.md): US Department Of Homeland Security · Washington, DC · Built 2004 · S/N 606 - [N802MR](https://openairdocs.org/aircraft/N802MR.md): Department Of Homeland Security · Washington, DC · Built 2005 · S/N 612 - [N803MR](https://openairdocs.org/aircraft/N803MR.md): Department Of Homeland Security · Washington, DC · Built 2006 · S/N 626 - [N804MR](https://openairdocs.org/aircraft/N804MR.md): US Department Of Homeland Security · Washington, DC · S/N 374 - [N805MR](https://openairdocs.org/aircraft/N805MR.md): US Department Of Homeland Security · Washington, DC · Built 2008 · S/N 655 - [N807EX](https://openairdocs.org/aircraft/N807EX.md): Frontera Flight Holdings Inc · Dover, DE · Built 1991 · S/N 292 - [N807MR](https://openairdocs.org/aircraft/N807MR.md): US Department Of Homeland Security · Washington, DC · Built 2009 · S/N 663 - [N808MR](https://openairdocs.org/aircraft/N808MR.md): US Department Of Homeland Security · Washington, DC · Built 2009 · S/N 667 - [N8100L](https://openairdocs.org/aircraft/N8100L.md): Dynamic Avlease Inc · Bridgewater, VA · Built 1989 · S/N 146 - [N8100V](https://openairdocs.org/aircraft/N8100V.md): Dynamic Avlease Inc · Bridgewater, VA · Built 1985 · S/N 024 - [N810MR](https://openairdocs.org/aircraft/N810MR.md): US Department Of Homeland Security · Washington, DC · S/N 590 - [N8200H](https://openairdocs.org/aircraft/N8200H.md): Dynamic Avlease Inc · Bridgewater, VA · Built 1997 · S/N 494 - [N8200J](https://openairdocs.org/aircraft/N8200J.md): US Special Operations Command · Tampa, FL · Built 1997 · S/N 478 Next page: https://openairdocs.org/ad/2004-05-21/aircraft.md?page=2 ## 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:2004-05-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-05-21') ORDER BY n_number ``` This list as a web page: https://openairdocs.org/ad/2004-05-21/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.