Skip to content

Registered aircraft · 162

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

N1179HMann Thomas A · Ford, WABuilt 1948 · S/N 15AC-190 N1182HWitherspoon Alexander · Sandy, ORBuilt 1948 · S/N 15AC-192 N1183HMelby Justin D · Stoughton, WIBuilt 1948 · S/N 15AC-194 N1186HLozier Jesse E · Coudersport, PABuilt 1948 · S/N 15AC-198 N1188HWitteveen Mark J · Kodiak, AKS/N 15AC-47 N1192HEberhardt William G · Orland, MEBuilt 1948 · S/N 15AC-204 N1203HZimmer Dennis DBA · Pennock, MNS/N 15AC-215 N1204HCompton Adam J · Wasilla, AKBuilt 1948 · S/N 15AC-216 N1209HNelson Chester C · Little Falls, MNBuilt 1948 · S/N 15AC-221 N1211HSchelde Jack D · Cook, MNBuilt 1948 · S/N 15AC223 N1224HCorcoran Timothy J · Aurora, ORFirst renewal noticeS/N 15AC-236 N1227HSutton Aircraft Salvage LLC · Palmer, AKBuilt 1948 · S/N 15-AC239 N1229HMattfield Weldon D · Bovey, MNFirst renewal noticeS/N 15AC-241 N1233HRamberg Stephen Jon · Saint Louis Park, MNS/N 15AC-245 N1234HSpear Tarik W · Fairbanks, AKBuilt 1948 · S/N 15AC246 N1235HTravis Michael D · Anchorage, AKBuilt 1948 · S/N 15AC-247 N1240HDestefano Patrick S · Bryan, TXS/N 15AC-252 N1250HPhelps Lee D · Juneau, AKBuilt 1947 · S/N 15AC-262 N1252HPallasch Cooper William · Denton, TXBuilt 1948 · S/N 15AC-264 N1253HTschepen Leo R · Bisbee, NDBuilt 1948 · S/N 15AC-265 N1261HGregg Larry R · Pine City, MNBuilt 1948 · S/N 15AC-273 N1264HSaladino Matthew G · Katy, TXBuilt 1948 · S/N 15AC-276 N1266HStoker Paul M · Wasilla, AKBuilt 1949 · S/N 15AC279 N1267HRetroair Restoration LLC · Big Lake, AKBuilt 1948 · S/N 15AC-278 N1270HBuehlman Peter · Laveen, AZBuilt 1948 · S/N 15AC-281 N1271HAmundson Kimber L · Eagle River, AKS/N 15AC-284 N1277HRegistered aircraftBuilt 1948 · S/N 15AC293 N1279HRichmond Brian G · Rhome, TXS/N 15AC-295 N1283HMurphy George W · Willow, AKS/N 15AC-299 N1285HWoodford John E · Madison, WIBuilt 1948 · S/N 15AC-301 N1287HNelson Chester C · Little Falls, MNBuilt 1948 · S/N 15AC-303 N1289HTranby Wayne A · Fargo, NDBuilt 1948 · S/N 15AC-306 N1293HAyers Mark T · Whitney, TXS/N 15-AC-311 N1294HWolbert Joseph P · Canton, GABuilt 1948 · S/N 15AC-318 N1301HFair David E · Anchorage, AKFirst renewal noticeBuilt 1949 · S/N 15AC-325 N1302HN1302h LLC · Levering, MIS/N 15AC-333 N1309HBrodie James W · Lind, WABuilt 1949 · S/N 15AC-340 N1312HZadnikar Brian M · Eveleth, MNBuilt 1949 · S/N 15AC-342 N1320HPoliti Terris P · Lake Placid, NYBuilt 1949 · S/N 15AC-354 N1322HSynnes Greggory M · Killdeer, NDBuilt 1949 · S/N 15AC-356 N1323HMcginnis John W · Strawberry Plains, TNBuilt 1948 · S/N 15AC-357 N1324HHudson Aircraft Service · Tallahassee, FLBuilt 1949 · S/N 15AC-359 N1329HDetwiler Chad R · Urbana, OHBuilt 1949 · S/N 15AC366 N1330HNelson Chester C · Little Falls, MNS/N 15AC-367 N1331HQualitair LLC · MichelstadtBuilt 1949 · S/N 15AC371 N1332HDrake Tyler M · Fairbanks, AKS/N 15AC-372 N1340HJacobs Robert C · Eureka, MTBuilt 1949 · S/N 15AC-380 N1345HNelson Chester C · Little Falls, MNBuilt 1949 · S/N 15AC-388 N1346HSchwing Emily E · Girdwood, AKS/N 15AC-389 N1348HKoepplinger Dawn M · Chesaning, MIBuilt 1949 · S/N 15AC-391

Back to Aeronca 15AC