Skip to content

Registered aircraft · 1,065

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

N7166FRegistration Pending · Kenly, NCRegistration pendingS/N 15063766 N7167FSteinhoff Daniel P · Santa Rosa, CABuilt 1966 · S/N 15063767 N7175FUS Flight Academy International Inc DBA · Post, TXBuilt 1966 · S/N 15063775 N7181FCarter Mark A · Carpinteria, CABuilt 1966 · S/N 15063781 N7183FN7183f LLC · Spanish Fork, UTBuilt 1966 · S/N 15063783 N7184FYoke Aviation LLC · Bowling Green, KYBuilt 1966 · S/N 15063784 N7187FHoranzy Paul S · N Grosvenordl, CTBuilt 1966 · S/N 15063787 N7188FCopeland Lance Andrew · Jacksonville, ARBuilt 1966 · S/N 15063788 N7189FTello Ricardo · Mission, TXBuilt 1966 · S/N 15063789 N7194Ajayi Samuel O · Fredericksburg, VAS/N 15063922 N7195FAustin Richard K · Ludington, MIBuilt 1966 · S/N 15063795 N7196FStarr Benjamin M · Somerset, OHBuilt 1966 · S/N 15063796 N7198FCessna Flyers LLC · Bountiful, UTBuilt 1966 · S/N 15063798 N7199FSale Reported · Pikeville, TNSale reportedBuilt 1966 · S/N 15063799 N73RJRichard Kent A · Sunset, LABuilt 1966 · S/N 15062833 N74KWWilling Kenneth Allen · Grasston, MNS/N 15063752 N751DSHigh Exposure Inc · Wilmington, DEBuilt 1965 · S/N 15062266 N764CPApmg Aircraft Management LLC · Las Vegas, NVBuilt 1965 · S/N 15061758 N76YSEstrada Ernesto Alejandro · Yuma, AZBuilt 1965 · S/N 15062483 N7700FClairy Scott M · Justin, TXBuilt 1966 · S/N 15063800 N7703FGonzales Donald M · Columbia Station, OHS/N 15063803 N7705FEisel Joseph D · Dexter, ORBuilt 1966 · S/N 15063805 N7709FChiang Yucheng · Glenview, ILBuilt 1966 · S/N 15063809 N7711FMcclain Eugene L · Maryville, TNBuilt 1966 · S/N 15063811 N7714FRegistration Pending · Oxford, MIRegistration pendingS/N 15063814 N7718FAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1966 · S/N 15063818 N7723FSchlueter Rodney E · Kansas City, MOBuilt 1966 · S/N 15063823 N7725FToney Michael · Saint Peters, MOBuilt 1966 · S/N 15063825 N7726FWargacki Darrin W · Hamilton, OHBuilt 1966 · S/N 15063826 N7729FCardenas Enrique · Brownsville, TXBuilt 1966 · S/N 15063829 N772ZZCirri Joseph A · Deming, NMBuilt 1966 · S/N 15064240 N7730FBmg Aviation Leasing LLC · Bloomington, INBuilt 1966 · S/N 15063830 N7731FN7731f LLC · Portage, MIBuilt 1966 · S/N 15063831 N7734FJackson Kimberly F · Wichita Falls, TXBuilt 1966 · S/N 15063834 N7737FChapman John · San Antonio, TXBuilt 1966 · S/N 15063837 N7741FHatch Donna L · Ballston Spa, NYBuilt 1966 · S/N 15063841 N7742FKovac Kenneth K · Mer Rouge, LABuilt 1966 · S/N 15063842 N7744FThoren Patrick · Tenino, WABuilt 1966 · S/N 15063844 N7752FBoulware James Curtis · New Smyrna Beach, FLBuilt 1966 · S/N 15063852 N7755FHayhurst Shane R · Winfield, PAFirst renewal noticeBuilt 1966 · S/N 15063855 N7761FSullivan Randall G · Liberty, TXBuilt 1966 · S/N 15063861 N7762FCosta Air Service LLC · Painted Post, NYS/N 15063862 N7763FRoss Joshua S · Homer, AKBuilt 1966 · S/N 15063863 N7764FAbouhatab Majed · Houston, TXBuilt 1966 · S/N 15063864 N7765FFilippone Chrristopher A · Ormond Beach, FLS/N 15063865 N7766FBuckman Bill · Lorenzo, TXBuilt 1966 · S/N 15063866 N7767FMorris Donald R · Murphysboro, ILS/N 15063867 N7772FCushing Aviation LLC · Red Wing, MNBuilt 1966 · S/N 15063872 N7773FDux Aaron T · Missoula, MTS/N 15063873 N7774FMurphy Jeffrey R · Newport, MNS/N 15063874

Back to Cessna 150F