Skip to content

Registered aircraft · 260

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

N4188U88 Uniform LLC · Jesup, GABuilt 1963 · S/N 15060188 N4198UMay David E · West Liberty, KYBuilt 1963 · S/N 15060198 N4199UTailwind Aviation LLC · Stafford, KSBuilt 1963 · S/N 15060199 N4200UPereira Jesse C · Medford, ORBuilt 1963 · S/N 15060200 N4202UVlk Mark J · Odessa, WABuilt 1963 · S/N 15060202 N4203UZeller Vernon B · Boonville, MOBuilt 1963 · S/N 15060203 N4205UCentral California Soaring Association Inc · Avenal, CABuilt 1963 · S/N 15060205 N4215UMaynard Paul E · Grand Junction, COBuilt 1964 · S/N 15060215 N4216UNaeve James M · Renton, WABuilt 1963 · S/N 15060216 N4221UMcwilliams Robert P · Belgrade, MTBuilt 1964 · S/N 15060221 N4226UKane Gabriel · Yucaipa, CABuilt 1963 · S/N 15060226 N4232USterling John A · Port Lavaca, TXS/N 150-60232 N4234UWasson Tina A · Lakeport, CABuilt 1964 · S/N 15060234 N4235UCottrell Mark C · Leitchfield, KYBuilt 1963 · S/N 15060235 N4237UMark & Debbe Inc DBA · Kalispell, MTS/N 15060237 N4239UStowell Thomas W · Gainesville, GABuilt 1963 · S/N 15060239 N4240UDennis P Berky Enterprises LLC · Winder, GAS/N 15060240 N4243UN4243u LLC · Wilmington, DEBuilt 1963 · S/N 15060243 N4248UEyles Benson G · Hampden, MEBuilt 1963 · S/N 15060248 N4250UBrownfield Bruce · Oak Park, CABuilt 1963 · S/N 15060250 N4253UConrad Chace D · Maryville, TNBuilt 1963 · S/N 15060253 N4256UGjm Aviation LLC · Petal, MSBuilt 1963 · S/N 15060256 N4260UGebhart Travis D · Meadow, SDBuilt 1963 · S/N 15060260 N4262UCrump Matthew A · Weatherford, TXBuilt 1963 · S/N 15060262 N4263UAdam Johnson · Sunray, TXBuilt 1964 · S/N 15060263 N4264UJones Craig R · Brighton, MIS/N 15060264 N4266UDoyle Paddy B · Homedale, IDBuilt 1963 · S/N 15060266 N4267UZeiset Luke R · Manchester, TNBuilt 1964 · S/N 15060267 N4268UWhitby Devin A · Dumfries, VABuilt 1964 · S/N 15060268 N4270USilvia Scott A · Valley Springs, CAS/N 15060270 N4273ULykens Valley Aviation · Lykens, PABuilt 1963 · S/N 15060273 N4277URegistration Pending · Anderson, SCRegistration pendingBuilt 1963 · S/N 15060277 N4278ULotze Stephen H · Burlington, WABuilt 1964 · S/N 15060278 N4283UMills George Thomas · Lagrange, GABuilt 1964 · S/N 15060283 N4284UBaker Ranches Inc · Baker, NVBuilt 1963 · S/N 15060284 N4288UPiper Kenneth R · Orwell, VTBuilt 1964 · S/N 15060288 N4291UTheis Industrial Leasing Inc · Spivey, KSBuilt 1963 · S/N 15060291 N4292UHayes John Lue · Shady Cove, ORBuilt 1963 · S/N 15060292 N4293UKelly Reginald David · Morehead City, NCBuilt 1964 · S/N 15060293 N4297UMondrik Michael R · Blessing, TXS/N 15060297 N4299UJohnson Daniel P · Williamsburg, IAS/N 15060299 N4302ULarson Gary L · Elgin, TXBuilt 1964 · S/N 15060302 N4303USherbak Michael J II · St Helena Is, SCBuilt 1963 · S/N 15060303 N4304UStoller Aircraft Rentals LLC · Sharpsburg, GAS/N 15060304 N4308UWildcat Aviation LLC · Schoolcraft, MIBuilt 1964 · S/N 15060308 N4310USport Wings Enterprises LLC · Pasadena, TXBuilt 1964 · S/N 15060310 N4312UDudley Benjamin H · Wasilla, AKS/N 15060312 N4315UYoung Margaret J · Peck, IDBuilt 1964 · S/N 15060315 N4318UCragg Gordon · Georgetown, TXBuilt 1964 · S/N 15060318 N4321UBurdett Michael R · Dawsonville, GABuilt 1964 · S/N 15060321

Back to Cessna 150D