Skip to content

Registered aircraft · 144

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

N5080XOber John A · Candor, NYBuilt 1968 · S/N 143 N5102TPettis Aviation LLC · Atlantic, IABuilt 1966 · S/N 72 N5105XManairco Inc · Wooster, OHBuilt 1969 · S/N 150 N5114THarlan Robert J · Kaycee, WYS/N 71 N5130TInfinity Aviation LLC · Piedmont, SDS/N 76 N5132XLinch Travis R · Belle Fourche, SDS/N 147 N5134TLawrence David Denton · Roanoke, VABuilt 1966 · S/N 75 N5138XKoprek Kevin A · Montrose, COBuilt 1969 · S/N 159 N5149XAmboni Sinesio Jr · Wasilla, AKBuilt 1969 · S/N 103 N5151XBazer Thomas E · Petersburg, AKBuilt 1969 · S/N 145 N5158XSchnell Troy A · Alliance, NEBuilt 1969 · S/N 163 N5160XCulver Deborah M · Anchorage, AKBuilt 1969 · S/N 166 N5161XSlease Brian D · North Pole, AKS/N 167 N5183XStory James W · Byhalia, MSBuilt 1969 · S/N 170 N5184XComstock Derrick B · Salol, MNBuilt 1969 · S/N 173 N5192XDavis Wayne W · Wakefield, RIBuilt 1969 · S/N 180 N5198XCornwell Thomas G Jr · Eatonville, WABuilt 1968 · S/N 128 N5213XSutton Aircraft Salvage LLC · Palmer, AKBuilt 1969 · S/N 177 N5214XHaltmann Sven · Fairbanks, AKBuilt 1969 · S/N 178 N5215XTilghman Glen A · Houston, AKBuilt 1969 · S/N 179 N5242XMilone Colin B · West Glacier, MTS/N 182 N5243XMcclung Aerial Spraying Inc · Big Springs, NEBuilt 1969 · S/N 186 N5244XFrantz William T · Wasilla, AKBuilt 1969 · S/N 184 N5247XTexas Skies Flight School LLC · Boerne, TXBuilt 1969 · S/N 183 N5252XGlick Caleb A · Hillsville, VABuilt 1969 · S/N 190 N5265XSwanton Peter K · Willits, CABuilt 1969 · S/N 124 N5266XKrabbenhoft J F · Amenia, NDBuilt 1969 · S/N 191 N5267XShelden Seth · Palmer, AKBuilt 1969 · S/N 192 N5271XRussell Steven N · Anchorage, AKBuilt 1969 · S/N 196 N59WLHerrmann Mark D · Dillingham, AKS/N 269-70 N5TEBythway William M · Painesville, OHBuilt 1968 · S/N 113 N6331NMartens Air Service LLC · North Platte, NEBuilt 1967 · S/N 89 N6350NLynn Robert W · Independence, WVBuilt 1967 · S/N 23 N6357NHamlin Andrew James · Fairbanks, AKBuilt 1967 · S/N 95 N66LKeating Gregory D · Carpenter, SDBuilt 1966 · S/N 60 N7100EStrickler Elizabeth D · Ringgold, TXBuilt 1984 · S/N 1215-84 N733MWWebb Matthew · Denton, TXBuilt 1967 · S/N 7GCBC-15 N7516FMahan Phillip A · Juneau, AKBuilt 1969 · S/N 198 N7518FKlassen Orvil H · Mountain Lake, MNS/N 200 N7519FBohlman Todd L · Lemon Grove, CABuilt 1969 · S/N 201 N7524FRobinson Robert L Jr · Homer, AKBuilt 1969 · S/N 207 N7527FProtsman Bryan D · Anchorage, AKBuilt 1969 · S/N 208-70 N7528FRausch Bruce Thomas · Marysville, OHBuilt 1969 · S/N 212-70 N7538FSwensen Nathan E · Winnemucca, NVS/N 209-70 N7539FHerkstroeter Caleb · Fairbanks, AKS/N 210-70 N7540FMeierotto Noah J · Two Rivers, AKBuilt 1969 · S/N 211-70 N7558FSchaller Lee · New Athens, ILBuilt 1969 · S/N 226-70 N7568FTranbarger Tad E · Macksville, KSBuilt 1969 · S/N 229-70 N7576FPfleger Michael K · Scottsdale, AZBuilt 1969 · S/N 231-70 N7578FUscola Merle Jay · Wasilla, AKS/N 233-70

Back to Champion 7GCBC