Skip to content

Registered aircraft · 1,439

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

N9409UFree Wade · Sharon, OKBuilt 1976 · S/N 15078357 N9412UGoshev Daniel Mihaylov · Gaithersburg, MDBuilt 1976 · S/N 15078360 N9418UAftcloud Inc · Ontario, CABuilt 1976 · S/N 15078366 N9420USouthquarter Aviation LLC · Youngstown, OHBuilt 1976 · S/N 15078368 N9422UHortman Ryan Davis · Summerville, SCBuilt 1976 · S/N 15078370 N9429UTangleport LLC · Amarillo, TXBuilt 1976 · S/N 15078377 N9437UAom Aircraft LLC · Wilmington, DES/N 15078385 N9439URautiola Patricia H · Rosemount, MNS/N 15078387 N9440USmith Peter I Trustee · Ocala, FLS/N 15078388 N9441ULewis Paul A · Spring, TXBuilt 1976 · S/N 15078389 N9444UB2w Corporation · Winona, MNBuilt 1976 · S/N 15078392 N9446UTepper Jesse J · New York, NYBuilt 1976 · S/N 15078394 N9448UValley View Farming Inc · Halsey, ORFirst renewal noticeS/N 15078396 N9451UPilot Pros Inc · Miami, FLBuilt 1976 · S/N 15078399 N9452UCurtis Marilyn D · Woodland, CABuilt 1976 · S/N 15078400 N9455UUniform Aircraft Holdings LLC · Ransom, ILS/N 15078403 N9457UClemens Jerry W · Parsons, KSBuilt 1976 · S/N 15078405 N9460UMarkham Clint D · Vinita, OKBuilt 1976 · S/N 15078408 N9463UMonday Terry A · Greenville, NCBuilt 1976 · S/N 15078411 N9467UPowell Travis R · Clinton, MOS/N 15078415 N9469UBrennecke Matthew L · Tulsa, OKBuilt 1976 · S/N 15078417 N9474UMay Randall T · Maquon, ILBuilt 1976 · S/N 15078422 N9475UGerlach Brett C · American Fork, UTBuilt 1976 · S/N 15078423 N9476USantos Enderson Rafael Teixeira Dos · Aledo, TXBuilt 1976 · S/N 15078424 N9477URegistration Pending · Delta Junction, AKRegistration pendingBuilt 1976 · S/N 15078425 N9480UColeman Stephen A · Wakefield, RIBuilt 1976 · S/N 15078428 N9481UParnell Jr Jerry · Panama City, FLBuilt 1976 · S/N 15078429 N9482UClark Josh D · Morehead, KYBuilt 1976 · S/N 15078430 N9487UCallejo Joseph S · Port Saint Lucie, FLBuilt 1976 · S/N 15078435 N9488UGardner Christopher · Addison, TXBuilt 1976 · S/N 15078436 N9489URodriguez Alonso Jr · Alamo, TXBuilt 1976 · S/N 15078437 N9494UAirgo Inc · Centralia, ILBuilt 1976 · S/N 15078442 N9499UFreer Paul Jr · Mount Airy, NCBuilt 1976 · S/N 15078447 N964MSMount San Antonio College · Walnut, CAS/N 15079165 N9785QStory Allen D · Arlington, TXBuilt 1975 · S/N 15076346 N98SSSoutheastern Oklahoma State University · Durant, OKBuilt 1977 · S/N 15079353 N990CAJundi Adam · North Royalton, OHBuilt 1976 · S/N 15079158 N999JTCdm Dirt LLC · Snowflake, AZBuilt 1976 · S/N 15079002 N9MDWaage Matthew L · Elkhart Lake, WIBuilt 1975 · S/N 15077170

Back to Cessna 150M