Skip to content

Registered aircraft · 87

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

N74206Chinn Larry · Anatone, WABuilt 1974 · S/N U20602457 N7485QEvans Charles H Trustee · Hooksett, NHBuilt 1973 · S/N U20602220 N773DWWalerius Dennis · Sylvania, OHBuilt 1976 · S/N U20603202 N78KWVolz James R · Laredo, TXBuilt 1974 · S/N U20602647 N78MWSymple Consulting LLC · Topeka, KSBuilt 1976 · S/N U20603205 N8225QCartoflight Inc · Willoughby, OHBuilt 1976 · S/N U20603109 N8264QMoody Bible Institute Of Chicago · Spokane Valley, WABuilt 1975 · S/N U20603125 N8274QBravo Delta II LLC · Steamboat Springs, COBuilt 1976 · S/N U20603135 N8275QAbel Derek R · Rio Vista, CABuilt 1976 · S/N U20603136 N8293QBaker Marianne J · Raeford, NCBuilt 1976 · S/N U20603154 N8409QFrey David G Jr · Grand Rapids, MIBuilt 1976 · S/N U20603269 N8462QPahrump Aviation LLC · Las Vegas, NVS/N U20603320 N8463QSmith James M · Star, IDBuilt 1976 · S/N U20603321 N8479QLake Airways Management LLC · Hazelhurst, WIBuilt 1976 · S/N U20603337 N8482QGregg Flying Service Inc · Durango, COBuilt 1976 · S/N U20603340 N8506QBell Robert C · Colby, KSS/N U20603363 N8523QLifetime Adventures LLC · Bellevue, MIBuilt 1976 · S/N U20603379 N8526QKenworthy Winston C · Odessa, TXBuilt 1976 · S/N U20603382 N8546QBlack Andrew J · Broomfield, COBuilt 1976 · S/N U20603402 N8576QThompson Robert Lee · Moore, OKBuilt 1976 · S/N U20603432 N8580QBald Eagle Aviation LLC · Oakley, UTBuilt 1976 · S/N U20603436 N858JAAms Aviation LLC · South Bend, INBuilt 1976 · S/N U20603437 N8598QTolley Samuel M · Rangely, COBuilt 1976 · S/N U20603453 N85PEMidwest Airmotive Inc · Mount Sterling, KYBuilt 1975 · S/N U20602774 N8647QTechnical Applications & Consulting LLC · Topeka, KSBuilt 1976 · S/N U20603463 N8725QN8725q LLC · Grand Junction, COBuilt 1976 · S/N U20603478 N8756QTriple 2 LLC · Burlington, COBuilt 1976 · S/N U20603509 N8758QBerge Christian · Mccall, IDBuilt 1976 · S/N U20603511 N888EAAustin E H Jr · San Antonio, TXBuilt 1976 · S/N U20603286 N9125YKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1976 · S/N U20603324 N917WCBarr Air Patrol LLC · Mesquite, TXBuilt 1973 · S/N U20602032 N922MATeton Leasing LLC · Pocatello, IDBuilt 1976 · S/N U20603467 N94NMSykes Gregory P · Arlington, WABuilt 1974 · S/N U20602336 N9549GMacica Stephen J DBA · Truckee, CABuilt 1972 · S/N U20601749 N9604GRoberts Development Company Inc · Tucson, AZBuilt 1972 · S/N U20601804 N9613GDavid W Easter Consulting Inc · Libby, MTBuilt 1972 · S/N U20601813 N9674GN1705r Inc · Cobb, CAS/N U20601874

Back to Cessna TU206F