Skip to content

Registered aircraft · 305

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 ('2073449')
  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 ('2073449')
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.

N2043SAppel Daniel E · Redfield, SDBuilt 1975 · S/N 21061010 N2046SYankee Clipper LLC · Dayton, OHFirst renewal noticeS/N 21061013 N2050SDavis Bryan C · Winfield, KSBuilt 1975 · S/N 21061017 N2056SAcevedo Adriel · San Antonio, TXBuilt 1975 · S/N 21061023 N2070SThompson Robert V Trustee · Crawford, COBuilt 1975 · S/N 21061037 N2076SWarden Air LLC · Warden, WABuilt 1975 · S/N 21061043 N2083SDave Schmauderer · Woodland, CAS/N 21061049 N2084SSecondhand Flying LLC · Ogden, UTBuilt 1975 · S/N 21061050 N2085SRichards John · Casa Grande, AZBuilt 1975 · S/N 21061051 N2092SMidwest Airmotive Inc · Mount Sterling, KYBuilt 1975 · S/N 21061058 N210ARVjc Air LLC · Katy, TXBuilt 1975 · S/N 21061077 N210AZAerialtraders LLC · Estero, FLBuilt 1972 · S/N 21059678 N210BHGlenn Wade Corp · Tucson, AZBuilt 1975 · S/N 21060954 N210CX210 Equipment LLC · Lexington, SCBuilt 1972 · S/N 210-59719 N210EUSky West Aviation Inc Trustee · Albuquerque, NMS/N 21061152 N210JWT M Holliday Inc · Chino Valley, AZBuilt 1975 · S/N 21061000 N210LCVentana Development Brazos LLC · Bay City, TXBuilt 1976 · S/N 21061298 N210MESouther Field Aviation Inc · Americus, GAS/N 21061123 N210NPDocflyers LLC · Leesburg, FLBuilt 1974 · S/N 21060436 N210TECenturion Flyers LLC · Crystal Bay, NVBuilt 1975 · S/N 210-60544 N210WTBarlowe James M · Enumclaw, WABuilt 1971 · S/N 21059528 N210WZHogue Tool & Machine Inc · Paso Robles, CABuilt 1973 · S/N 21060039 N2118SAbes Erika · El Paso, TXBuilt 1975 · S/N 21061081 N211LCSuddarth Steven Craig · Edgewood, NMBuilt 1974 · S/N 21060364 N2122SBobo Construction LLC · Pullman, WABuilt 1975 · S/N 21061084 N2138SStamm Roy Peter · Woodstock, GABuilt 1975 · S/N 21061099 N2143SBaiocchi Ken P · San Jose, CABuilt 1975 · S/N 21061104 N2145SHenry James · Bonita, CABuilt 1975 · S/N 21061106 N2175SMichael Lauder K · Littleton, COBuilt 1975 · S/N 21061136 N2181SGreer Kenneth R · Pittsburgh, PABuilt 1975 · S/N 21061142 N219BTDacy Justin A · Boerne, TXBuilt 1976 · S/N 21061568 N220WBWells Propane Inc · Wells, NVBuilt 1974 · S/N 210-60194 N22121Registration Pending · Georgetown, TXRegistration pendingBuilt 1972 · S/N 21059711 N22232Engeseth James Jr · Parker, COBuilt 1972 · S/N 21059730 N2223SDavis Aaron B · Lascassas, TNBuilt 1976 · S/N 21061168 N2235SN2235s LLC · Overland Park, KSBuilt 1976 · S/N 21061180 N22459Hatch Leasing Company LLC · Flagstaff, AZBuilt 1972 · S/N 21059754 N2247SCarnes Andrew P · Wichita Falls, TXBuilt 1976 · S/N 21061191 N2249SDlw Flight Services LLC · Waterloo, ILBuilt 1976 · S/N 21061193 N2252SSpider Lips Aviation LLC · Fischer, TXBuilt 1976 · S/N 21061196 N2259SFaireyfam Aviation LLC · Saint George, UTBuilt 1976 · S/N 21061203 N2260SWheeler Eugene N · Livermore, CABuilt 1976 · S/N 21061204 N2262SKoch Phillip E · Eldon, MOBuilt 1976 · S/N 21061206 N22650Sackett Gary G · Millcreek, UTFirst renewal noticeBuilt 1972 · S/N 21059767 N2266SWeekend Air LLC · Incline Village, NVBuilt 1976 · S/N 21061210 N22EPRobinson Michael · Tucson, AZBuilt 1972 · S/N 21059773 N22KMTorris Warren E · San Dimas, CABuilt 1973 · S/N 21060132 N2317GOrion Aviation LLC · Edmond, OKS/N 21061485 N2319SHotel Whiskey Aviation LLC · San Antonio, TXBuilt 1976 · S/N 21061245 N2375SLundin Lawrence D · Midvale, IDBuilt 1976 · S/N 21061257

Back to Cessna T210L