Skip to content

Registered aircraft · 1,063

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.

N1114TQuellette James L · Plymouth, CTBuilt 1965 · S/N 15061846 N1227RRegistration Pending · Laie, HIRegistration pendingBuilt 1965 · S/N 15062347 N14GLMc Flying Club Inc · Lewistown, PABuilt 1966 · S/N 15063346 N1500TAguilar Honorio · Anna, TXBuilt 1965 · S/N 15061784 N150BWRollinson Mark H · South CanterburyS/N 15064521 N150CQCalarco Richard A · Hillsboro, ORBuilt 1965 · S/N 15061671 N150HWilliams Zachary · Jackson, MIS/N 15063910 N150HFRegistration Pending · Garden Grove, CARegistration pendingBuilt 1965 · S/N 15062350 N150PWCampbell Andrew H · Sammamish, WABuilt 1966 · S/N 15063380 N160CBBishop Christopher S · Houston, TXBuilt 1966 · S/N 15063780 N16KFFournier Louis W · Fort Worth, TXBuilt 1965 · S/N 15061619 N171RJSawyer Eric O · Redding, CABuilt 1966 · S/N 15063038 N202WPStow Andrew Geoffrey · Peoria, ILS/N 15063024 N242XFour Aces Montana LLC · Missoula, MTBuilt 1965 · S/N 15062062 N249MCTharp Angela K · Wentzville, MOBuilt 1965 · S/N 15061789 N2823SSpark Aero LLC · Christiansburg, VABuilt 1965 · S/N 15062301 N28822Edwards Gordon O · Casper, WYBuilt 1966 · S/N 15063015 N2974ULeibach Frederick A · Peoria, ILBuilt 1965 · S/N 15062332 N3003XAero Flyers LLC · Stephenson, VABuilt 1966 · S/N 15064403 N3005XOso Air LLC · Missoula, MTBuilt 1966 · S/N 15064405 N3006XRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1966 · S/N 15064406 N3007XKelley Keith B · Forney, TXBuilt 1966 · S/N 15064407 N3008XAdams Harold L · Beaver, OHBuilt 1966 · S/N 15064408 N3009XWarren Jeremy I · Horse Cave, KYBuilt 1966 · S/N 15064409 N300YWShell John E · Waverly, OHBuilt 1966 · S/N 15062936 N3012XByrne Matthew A · West Allis, WIBuilt 1966 · S/N 15064412 N3013XGreeneway Charles G · Armour, SDBuilt 1966 · S/N 15064413 N3017XMunson Timothy G · Mendota, ILBuilt 1966 · S/N 15064417 N3018XWard David J · Garden Valley, IDBuilt 1966 · S/N 15064418 N3019XSkyy King LLC · Helena, MTBuilt 1966 · S/N 15064419 N3020XLima 2 Aviation Of Mississippi LLC · Bogue Chitto, MSBuilt 1966 · S/N 15064420 N3021XMay'S Welding Service Inc · Cotulla, TXS/N 15064421 N3022XCintim LLC · Carrabelle, FLS/N 15064422 N3024XDavis James M · Tuscaloosa, ALBuilt 1966 · S/N 15064424 N3027XSchneider Benjamin J · Wheeling, WVBuilt 1966 · S/N 15064427 N3028XFicken Jerome L · Cedar Hill, MOBuilt 1966 · S/N 15064428 N3029XRegistered aircraftS/N 15064429 N3032XMagaruh George M · Roscoe, ILBuilt 1966 · S/N 15064432 N3034XChandler Jerry D · Pilot Mountain, NCBuilt 1966 · S/N 15064434 N3035X29 Soaring Club Inc · Twentynine Palms, CABuilt 1966 · S/N 15064435 N30384Knutson Wayne R · Thompson, NDS/N 15064473 N3041XSky Partners LLC · Sylacauga, ALBuilt 1966 · S/N 15064441 N3043XVaughan John T · Safety Harbor, FLBuilt 1966 · S/N 15064443 N3047XSmith Richard D DBA · Williamstown, OHBuilt 1966 · S/N 15064447 N3048XVisconti Phillip M · Hominy, OKBuilt 1966 · S/N 15064448 N3053XVoigt Richard D · La Vernia, TXBuilt 1966 · S/N 15064453 N3054XHeidt Daniel A · Opelika, ALBuilt 1966 · S/N 15064454 N3055XChickasha Wings Inc · Chickasha, OKBuilt 1966 · S/N 15064455 N3056XSmith Chelsea R · Louisville, KYBuilt 1966 · S/N 15064456 N3057XSoules William P · Las Cruces, NMS/N 15064457

Back to Cessna 150F