Skip to content

Registered aircraft · 151

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

N12TLLoofbourrow Travis S · Houston, TXBuilt 1968 · S/N 60 N1604GMut Henry · Brookshire, TXBuilt 1968 · S/N 101 N1605GAllen Matthew C · Pomona, CABuilt 1968 · S/N 99 N1606GNigri David A · Smithfield, RIBuilt 1968 · S/N 112 N1608GDrexler William G · Peyton, COBuilt 1968 · S/N 105 N1620GDrexler Charles T · Albuquerque, NMBuilt 1968 · S/N 123 N1631GSwiger Cale W · Hendersonville, TNBuilt 1968 · S/N 127 N1637GLejeune Robert S · Basile, LABuilt 1968 · S/N 113 N1639GGhostwriter Airshows LLC · Hustonville, KYBuilt 1968 · S/N 115 N1640GTownsend Gary V · Sunderland, VTS/N 116 N1642GLetourneau University · Longview, TXBuilt 1969 · S/N 169 N1650GWright Jeffrey Crandel · Opelika, ALBuilt 1968 · S/N 128 N1675GKraft Jesse · Twain Harte, CAS/N 130 N1676GCain Landa B · San Diego, CAS/N 131 N1680GSears Richard A · Stevensville, MDBuilt 1968 · S/N 135 N1684GMitchell Gary N · Kansas City, KSBuilt 1968 · S/N 139 N1690GRansom Bryce P · Richland, ORS/N 75 N1695GSmith Winston R · Durham, NCBuilt 1968 · S/N 141 N1832GThomas Robert D Jr · Tulsa, OKS/N 86 N1840GJulicher Mark R · Bulverde, TXBuilt 1968 · S/N 79 N1843GWincar Air LLC · Doniphan, NEBuilt 1968 · S/N 78 N1844GTwenty One Miles LLC · Woodland Hills, CABuilt 1968 · S/N 84 N1847GRogers Joe E · Manvel, TXBuilt 1968 · S/N 91 N1850GMadison Nicholas R · Fayette, ALBuilt 1968 · S/N 92 N1865GCallie Capital LLC · Prairie Village, KSBuilt 1968 · S/N 97 N1871GGrizzle Jason · Roscoe, TXBuilt 1968 · S/N 107 N1885GGoodfriend Neal · Sanger, TXS/N 144 N1889GRainbow Flying Service LLC · Moses Lake, WABuilt 1968 · S/N 93 N1951EMcclure Steve · Lebanon, INBuilt 1968 · S/N 81 N209JFStock James D · Deer Park, WABuilt 1967 · S/N 76 N2574GScholl John D · Alexandria, MNBuilt 1967 · S/N 55 N2606GMiles Aviation LLC · Utica, KYBuilt 1967 · S/N 51 N2614GNorthern Air Inc · Bonners Ferry, IDBuilt 1967 · S/N 64 N2628GArsenault Donald S · Round Rock, TXBuilt 1967 · S/N 53 N2751GSpears Patricia C · Longmont, COBuilt 1967 · S/N 56 N2753GJans Dream Machine LLC · Lewes, DES/N 66 N2839GGereg James J · Danbury, CTBuilt 1967 · S/N 65 N288RTSavonen Stephen D · Ukiah, CABuilt 1967 · S/N 7KCAB-43 N2940GDakota Air Spray LLC · Huron, SDBuilt 1967 · S/N 69 N2992GYonge Charles Richard · Ocala, FLBuilt 1967 · S/N 68 N2995GVincent Frederick D · Searsport, MEBuilt 1967 · S/N 38 N3045GSlack Troy Trustee · New Concord, OHBuilt 1968 · S/N 49 N323VWSonoran Aero LLC · Phoenix, AZBuilt 1971 · S/N 260-71 N3999YSlyman David F · Inver Grove, MNBuilt 1969 · S/N 7KCAB-225 N443ERivenbark Michael Keith · Clinton, NCS/N 102 N5063XGrundy James W · West Greenwich, RIBuilt 1968 · S/N 145 N5064XHuber Bryan L · Jonesboro, ARBuilt 1968 · S/N 146 N5065XWallace Aviation Inc · Wallace, NEBuilt 1968 · S/N 147 N5066XChandelle LLC · Chelsea, ALBuilt 1968 · S/N 149 N5067XMiller Johnny D · Rhome, TXS/N 150

Back to Champion 7KCAB