Skip to content

American Legend AL11

Registered aircraft · 45

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('060002N', '069002F')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('060002N', '069002F')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N103RDWells Christopher · Weatherby Lake, MOS/N AL-1060 N116LCRonnies Aircraft Sales Llp · Pittsfield, MABuilt 2007 · S/N AL-1097 N118LLFinney James R · Howe, TXBuilt 2007 · S/N AL-1114 N1313VColsoncin Trenton A · Breckenridge, TXS/N AL-1040 N149MRRaper Miles M · Doral, FLBuilt 2006 · S/N AL-1055 N16PZKnapp Frank E · Palmer, AKBuilt 2008 · S/N AL-1129 N177TLClark Melvin G · Sunnyvale, TXS/N AL-1074 N18AECollins Jeremy R · Bluffton, INBuilt 2006 · S/N AL-1037 N198BFRc Aero LLC · Richmond, INBuilt 2008 · S/N AL-1126 N216PTWorkman Irene E · Creston, OHBuilt 2010 · S/N AL-1156 N246RMBroadmoor Consulting LLC · Benton, LABuilt 2007 · S/N AL-1099 N2480Zimmerman Phillip B · Athens, TXS/N AL-1068 N25NPA-Z Aviation LLC · Bay City, MIBuilt 2013 · S/N TX-1025 N28ZXDickson Kenneth R · Louisville, KYBuilt 2006 · S/N AL-1067 N31813Bsl Aviation Inc · Shreveport, LABuilt 2006 · S/N AL-1063 N335JBComer Nathan A · Statesville, NCBuilt 2007 · S/N AL-1088 N373RJMonson Dirk E · Glasgow, MTS/N AL-1056 N3751CLandry Kevin F · Saint Amant, LABuilt 2008 · S/N AL-1121 N37YZCollins John J · Manitowoc, WIBuilt 2008 · S/N AL1130 N404PCLegend Aire LLC · Mitchell, SDBuilt 2007 · S/N AL-1093 N417JGRice Clifford H Sr · Natchitoches, LABuilt 2008 · S/N AL-1123 N456USMartin Daniel J · Katy, TXBuilt 2008 · S/N AL-1136 N471JBBelmore William · Maynard, MAS/N AL-1039 N47HDNo Limits Aviation Inc · Hayden, IDS/N AL-1049 N537JMN537jm LLC · Hartford, IAS/N AL-1100 N53FMHascall Michael L · Palmetto, FLBuilt 2016 · S/N TX-1038 N60NGMcpherson Joseph Miller · Benson, AZBuilt 2008 · S/N AL-1141 N6277Tommys Tiger LLC · Homestead, FLS/N AL-1038 N647PJHickory Ridge Farms LLC · Brooklet, GABuilt 2009 · S/N AL-1146 N701LBLima Bravo Aviation LLC · Wilmington, DEBuilt 2010 · S/N AL-1154 N722HMRegistered aircraftBuilt 2007 · S/N AL-1098 N729CJOld School Flying LLC · Stuart, FLBuilt 2008 · S/N AL-1133 N741WN741w LLC · Stuart, FLS/N AL-1044 N758DBTtl Aero LLC · Oklahoma City, OKS/N AL-1045 N7645ABroten Sara B · Roseau, MNBuilt 2008 · S/N AL1124 N787MVMarohn Matthew P · Maple Lake, MNBuilt 2007 · S/N AL-1101 N797WDBuraceski John S · Faribault, MNBuilt 2007 · S/N AL-1092 N848LCStrodtbeck Dale G · Anchorage, AKS/N AL-1047 N865JDumm Jamie Lee · Strongstown, PABuilt 2007 · S/N AL-1113 N872DPennington Carl B Jr · Elm City, NCBuilt 2007 · S/N AL-1109 N906DFPoe Joshua J · Peculiar, MOS/N AL-1066 N915BBBain Sterling Jr · Alexandria, LABuilt 2007 · S/N AL-1090 N9621Aero Eleven20 LLC · Mckinney, TXBuilt 2008 · S/N AL-1120 N96LCDomich Jeffrey E · Petaluma, CABuilt 2006 · S/N AL-1075 N989MDDrewry James D · Dayton, TXBuilt 2007 · S/N AL-1116

Back to American Legend AL11