Skip to content

Registered aircraft · 659

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

N61020Houk Sean R · Lyons, OHBuilt 1969 · S/N 15070739 N61026Johnson David A · Dover, OHBuilt 1969 · S/N 15070744 N61028Berendes Jay R · Shullsburg, WIBuilt 1969 · S/N 15070746 N61030Balderrama Arturo · Mcminnville, ORBuilt 1969 · S/N 15070748 N61031Pacific Aircraft Services · Aurora, ORBuilt 1969 · S/N 15070749 N61033Dame John D · Omaha, NEBuilt 1969 · S/N 15070751 N61038Bartholomew Howard R Jr · Mechanicsburg, PABuilt 1969 · S/N 15070755 N61041Pattison Aero Inc · Upland, CABuilt 1969 · S/N 15070758 N61051Crispin Michael J · Broadalbin, NYBuilt 1969 · S/N 15070765 N61052Secker-Walker Hugh E · Newburyport, MAS/N 15070766 N61055Booher Tabitha O · Livingston, TNBuilt 1969 · S/N 15070768 N61057Provenzano Jeremy E · Aurora, COBuilt 1969 · S/N 15070770 N61061Townsend John J · Valliant, OKBuilt 1969 · S/N 15070773 N61062Bate David F · Vanceburg, KYBuilt 1969 · S/N 15070774 N61064N61064 LLC · Forest Park, ILBuilt 1969 · S/N 15070775 N61067Connolly Luile A · Blaine, MNBuilt 1969 · S/N 15070777 N61075Evan R Charles · Riverside, CAS/N 15070780 N61077Ray Albert B · Prosser, WAS/N 15070782 N61078Registered aircraftBuilt 1969 · S/N 15070783 N61081Beattie Mark A · Anaheim, CABuilt 1969 · S/N 15070784 N61091O'Flynn Brian · Mimbres, NMBuilt 1969 · S/N 15070794 N61094Harper Kevin J · Valley Center, KSBuilt 1969 · S/N 15070795 N61097Giles David Victor · Gilbert, AZBuilt 1969 · S/N 15070798 N61104Backwoods Air LLC · Caro, MIBuilt 1969 · S/N 15070803 N61108Umrysz Jeffrey E · Mystic, CTBuilt 1969 · S/N 15070807 N61110Veit Brett Allen · Willis, TXS/N 15070809 N61112Ralph Joshua C · Wichita, KSS/N 15070811 N61114Thomas O Bailey · Sutton, NDBuilt 1969 · S/N 15070813 N61120Jstream Lc · Sheridan, WYBuilt 1969 · S/N 15070814 N61123Starnes Robert D · Lavonia, GABuilt 1969 · S/N 15070816 N61126Roth Jason G · Seattle, WABuilt 1969 · S/N 15070819 N61127Mcgill Phil · Huntsville, ALBuilt 1969 · S/N 15070820 N61129Jones Flying Service LLC · Pulaski, TNS/N 15070822 N61130Registration Pending · Wilmington, DERegistration pendingBuilt 1969 · S/N 15070823 N61131Anderson Jerry · Vacaville, CABuilt 1969 · S/N 15070824 N61132Whithaus Douglas A · Panama City, FLBuilt 1969 · S/N 15070825 N61140Johnson Darryl W · Fowler, COBuilt 1969 · S/N 15070831 N61141Holmes Meg C · Winterport, MEBuilt 1969 · S/N 15070832 N61143Hedlund Wesley H · Newburgh, MEBuilt 1969 · S/N 15070834 N61144Schenk Flight Service LLC · Ainsworth, NEFirst renewal noticeBuilt 1969 · S/N 15070835 N61145N61145 LLC · Seattle, WAS/N 15070836 N61152Cunneen Regan M · Vista, CABuilt 1969 · S/N 15070841 N61156Williams Tommy J · San Angelo, TXBuilt 1969 · S/N 15070845 N61157Bravo Holdings LLC · St Francis, WIBuilt 1969 · S/N 15070846 N61159Stenger D James Trustee · Sonora, CABuilt 1969 · S/N 15070847 N61163Miller William M · Enterprise, KSBuilt 1969 · S/N 15070851 N61166Om Air LLC · Saint Louis, MOS/N 15070852 N61168Sherwood Ronald R · Kathleen, GABuilt 1969 · S/N 15070854 N61172Celeste Nash · Vista, CAS/N 15070858 N61176Closson Dennis L · Red Wing, MNBuilt 1969 · S/N 15070862

Back to Cessna 150J