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.

N714QLGround School Flight Training LLC · Lewes, DES/N 15079350 N714QMRichardson David H · Sidell, ILBuilt 1977 · S/N 15079351 N714QQJacobsen Sandra N · Moab, UTBuilt 1977 · S/N 15079354 N714QSMaharaj Narad · Morgantown, WVBuilt 1977 · S/N 15079356 N714QWA Parrottes View In Flight LLC · Wilmington, DEBuilt 1977 · S/N 15079360 N714QXLewis Justin S P · Choctaw, OKBuilt 1977 · S/N 15079361 N714RBStewart Family Ranch Inc · Chadron, NES/N 15079365 N714RCWebster Richard Eric · West Valley City, UTS/N 15079366 N714RFB2 Aviation LLC · Hopkinsville, KYBuilt 1977 · S/N 15079369 N714RGLumgair David R · Painter, VAS/N 15079370 N714RNHubler Alvin J Jr · Elizabethtown, PABuilt 1977 · S/N 15079376 N714RPSapp Michael B · Burlington, NCBuilt 1977 · S/N 15079377 N714RRMcburney Gary N · Apple Valley, CABuilt 1977 · S/N 15079379 N714RSBeefair LLC · Kalispell, MTBuilt 1977 · S/N 15079380 N714RVPataky Edward F Jr · Nashville, TNBuilt 1977 · S/N 15079383 N714SGAce Aviators LLC · Mcdonough, GABuilt 1977 · S/N 15079393 N714SKAlaska Sky School LLC · Anchorage, AKBuilt 1977 · S/N 15079396 N714SLSopko Mark W · Flagtown, NJBuilt 1977 · S/N 15079397 N714SPBoyer Steven L · Wooster, OHBuilt 1977 · S/N 15079400 N714SSPierce Jeanne E · Wellington, NVBuilt 1977 · S/N 15079403 N714SVStookey Aaron M · Mesa, AZBuilt 1977 · S/N 15079405 N722LAllen Steven C · Crittenden, KYBuilt 1976 · S/N 15078489 N737PACape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1976 · S/N 15078021 N7460GHelping 24 Hours LLC · Goodyear, AZS/N 15077663 N74UAnderson Ray L · Auburn, CAFirst renewal noticeBuilt 1977 · S/N 15079197 N7515UUren Peter J · Redwood Falls, MNS/N 15077732 N752MFEpperly David J · New Richmond, WIBuilt 1974 · S/N 15075977 N7538UHooper Lawrence S · Melba, IDBuilt 1975 · S/N 15077734 N7539UAirgo Inc · Centralia, ILS/N 15077735 N7559UFreeman Jet LLC · Cape Coral, FLBuilt 1975 · S/N 15077736 N7562USchuebel Douglas R · Cameron, WIBuilt 1978 · S/N 15077738 N7564USabatowich Erik J · Detroit, MIBuilt 1975 · S/N 15077740 N7572UAirfrank Inc · Hackensack, NJBuilt 1975 · S/N 15077741 N7581UOse Leroy B · Thief River Falls, MNS/N 15077748 N7583UMcgilvray Jerry Alan · Clayton, ALBuilt 1975 · S/N 15077750 N7585UMoody Joshua Michael · Springfield, ORBuilt 1975 · S/N 15077752 N7590UWilson Bobby L · Murray, KYS/N 15077757 N7591UBarbour Benjamin · Huntersville, NCBuilt 1975 · S/N 15077758 N7592UMiller Collin · Allen, TXBuilt 1975 · S/N 15077759 N7595UClavel Carl R · North Platte, NEBuilt 1975 · S/N 15077761 N75WCCedar Valley Air LLC · Lehi, UTS/N 15076045 N7604UWings Flight Enterprises Inc · Danville, KYBuilt 1975 · S/N 15077766 N760CAMcculloch Matthew L · Stoutland, MOBuilt 1975 · S/N 15076356 N7616UShepard Gregory W · Fort Myers, FLBuilt 1975 · S/N 15077770 N7617URikki Air LLC · Clarksville, TXBuilt 1975 · S/N 15077771 N7649URey Henry R · Fresh Meadows, NYBuilt 1975 · S/N 15077775 N7655USitta Donald C · Farmington, NMBuilt 1976 · S/N 15077781 N7658URegistration Pending · Oregon City, ORRegistration pendingBuilt 1976 · S/N 15077784 N7661USweitzer Cameron D · Warrensburg, MOBuilt 1976 · S/N 15077787 N7662UMcintyre James C · Bethlehem, PABuilt 1976 · S/N 15077788

Back to Cessna 150M