Skip to content

Registered aircraft · 387

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

N6526THilt Destin R · Auburn, CABuilt 1960 · S/N 17926 N6528TRogers Brian D · Pacific, MOBuilt 1960 · S/N 17928 N6529TCarncross Jerome W · Arlington, WIS/N 17929 N6532TRich Jay A · N Salt Lake, UTBuilt 1960 · S/N 17932 N6533TCrawford Daniel G Trustee · Dryden, MIBuilt 1960 · S/N 17933 N6540TDevito David E · Maple Valley, WABuilt 1960 · S/N 17940 N6543TLequire Wayne A · Maryville, TNBuilt 1960 · S/N 17943 N6545TWallis Jamee G · Auke Bay, AKBuilt 1960 · S/N 17945 N6546TDungy Garold E · Gower, MOBuilt 1960 · S/N 17946 N6552TSchuebel Douglas R · Cameron, WIBuilt 1960 · S/N 17952 N6554TDunaisky Joseph P · Randall, MNBuilt 1960 · S/N 17954 N6556TLandgaard James R · Peachtree City, GABuilt 1960 · S/N 17956 N6557THelena Vocational Technical Center · Helena, MTBuilt 1960 · S/N 17957 N6558TSmith Gregory C · Geneva, ILBuilt 1960 · S/N 17958 N6563TSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1960 · S/N 17963 N6566TJensen Christopher · Ooltewah, TNBuilt 1960 · S/N 17966 N6568TElf Aviation LLC · Franklin, TNS/N 17968 N6571TJohnson Bryan K · Lafayette, LABuilt 1960 · S/N 17971 N6574TSan Diego Community College District · San Diego, CAS/N 17974 N6575TSetzer Theodore E · Granite Falls, WAS/N 17975 N6576TShields Aidan J · Soldotna, AKBuilt 1960 · S/N 17976 N6577TRegistration Pending · Milton, DERegistration pendingBuilt 1960 · S/N 17977 N6580TOlson Kenneth L · Raymond, WABuilt 1960 · S/N 17980 N6592TLill Steve P · Lafayette, LAFirst renewal noticeBuilt 1960 · S/N 17992 N6596TSuss Charles · Woodford, VTS/N 17996 N6598TSwanson Duane R · Simi Valley, CABuilt 1960 · S/N 17998 N6601THoting John M · Santa Rosa, CAS/N 59001 N6604TGrimes Matthew K · Norman, OKBuilt 1960 · S/N 59004 N6616TTechnical Education Services Inc · Virginia Beach, VABuilt 1960 · S/N 59016 N6617TMacario T Michael III · Townsend, DEFirst renewal noticeBuilt 1960 · S/N 59017 N661ETGorton Peter V · Tucson, AZBuilt 1960 · S/N 59013 N717SXRegistration Pending · Monhans, TXRegistration pendingBuilt 1959 · S/N 17453 N7700EBachman Aviation Inc · Winter Haven, FLBuilt 1959 · S/N 17500 N7702EWhite Don DBA · Mount Vernon, WABuilt 1959 · S/N 17502 N7705EGerber James R · Larchwood, IABuilt 1959 · S/N 17505 N7711EHeaton Stewart · Spanish Fork, UTBuilt 1959 · S/N 17511 N7713EFitzgerald Keith M · Coopersburg, PABuilt 1959 · S/N 17513 N7718EHeuser Timothy J · Cottage Grove, ORS/N 17518 N7719EOlson Ben A · Gig Harbor, WAS/N 17519 N7720EAircraft Systems Group Inc · Odessa, FLBuilt 1959 · S/N 17520 N7729EMaldonado Abel N · Santa Maria, CABuilt 1959 · S/N 17529 N7734ERegistration Pending · Cheyenne, WYRegistration pendingBuilt 1959 · S/N 17534 N7738EKrueger Arthur G · Cottonwood, CABuilt 1959 · S/N 17538 N7742ERegistered aircraftBuilt 1959 · S/N 17542 N7748EKuntz William · Wilmington, NCS/N 17548 N7749EGrant Matthew D · Alvord, TXBuilt 1959 · S/N 17549 N7752EKountz Harvey J · Brockway, MTBuilt 1959 · S/N 17552 N7754EBurns Robert M III · Columbia, SCS/N 17554 N7757EIvanchenko Sergey · Phoenix, AZBuilt 1959 · S/N 17557 N7758EShannon Jon M · Conroe, TXBuilt 1959 · S/N 17558

Back to Cessna 150