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.

N1014MWeisinger Jason Aaron · Kyle, TXBuilt 1969 · S/N 15070994 N1015MEppenbrock Elena C · Fort Worth, TXS/N 15070995 N1021MMcconnell Frank V Jr · Woodstock, GABuilt 1969 · S/N 15070991 N1058MAir Combat Museum · Springfield, ILBuilt 1969 · S/N 15070998 N111TBNeswest Inc · Los Angeles, CABuilt 1968 · S/N 15069477 N1138ZRegistration Pending · Anchorage, AKRegistration pending, pending cancellationBuilt 1969 · S/N 15069760 N117TSRegistration Pending · Portland, MERegistration pendingBuilt 1968 · S/N 15069427 N126SMMathis Shannon Dwayne · Richmond, KYBuilt 1969 · S/N 15070492 N128RRRegistered aircraftS/N 15070734 N12MMHigh Exposure Inc · Wilmington, DEBuilt 1968 · S/N 15069873 N142SBSopha Kim A · Poynette, WIBuilt 1969 · S/N 15070717 N14CWThornwall Gregory C · Boonsboro, MDBuilt 1969 · S/N 15070656 N150ARBerry Norman R · Knoxville, TNS/N 15070693 N150BKTribec Inc · Medina, OHBuilt 1969 · S/N 15070857 N150DKShipe Jacqueline M · Louisville, TNBuilt 1968 · S/N 15069738 N150EHPouya Hamid · San Jose, CABuilt 1969 · S/N 15070883 N150FJSale Reported · Crystal, MNSale reportedBuilt 1969 · S/N 15071001 N150FLBerry Jeffrey Thomas · Clovis, CABuilt 1969 · S/N 15070938 N150KBWord James A · Honey Grove, TXS/N 15070723 N150QWard David T · Ewa Beach, HIBuilt 1969 · S/N 15070215 N150SQEasterling John · Littlerock, CAS/N 15070589 N150TNExecutive Wings LLC · Bolivar, TNBuilt 1968 · S/N 15069553 N151GWSale Reported · Avondale, COSale reported, pending cancellationS/N 15070186 N152MLBright Trevis Lee · Marion, INBuilt 1969 · S/N 15070431 N200SDKing Dwayne W · Sutton, AKBuilt 1969 · S/N 15070651 N208KCAcevedo Adriel · San Antonio, TXS/N 15070435 N222QAKlopotek Jerome P · Orangevale, CABuilt 1969 · S/N 15070543 N222TADeschene Michael R · Westminster, CABuilt 1968 · S/N 15069729 N225KCJr Imaging Logistics Inc · Pasco, WABuilt 1969 · S/N 15070197 N277RTGonzalez Edwin A · Scott Afb, ILBuilt 1968 · S/N 15070021 N308CCRobinson Earl A · Pageland, SCBuilt 1969 · S/N 15070954 N316PCRegistration Pending · Payson, AZRegistration pendingBuilt 1968 · S/N 15069440 N319DDenimarck Vincent · Wildwood, FLBuilt 1969 · S/N 15070159 N333QAFirth Lynn C · Auburn, NHBuilt 1968 · S/N 15069983 N333SHVitez David D · Morgantown, WVBuilt 1969 · S/N 15070617 N34TKWilkinson Paul R · Colonial Beach, VABuilt 1969 · S/N 15070364 N372DRees Ryan G · Loa, UTS/N 15070466 N379PFRegistered aircraftS/N 15069689 N37PPParsons Paul M · Aurora, COBuilt 1968 · S/N 15069944 N390DMGurrola Joseph C · Redlands, CABuilt 1969 · S/N 15070334 N3JTMcdannel Albert M · Laporte, INS/N 15070621 N4597RSanta Cruz Airplane LLC · Santa Cruz, CABuilt 1969 · S/N 15070525 N46CAEnglehart James C · Marietta, GABuilt 1969 · S/N 15070135 N50465Howard Wayne A · Loon Lake, WABuilt 1968 · S/N 15069322 N50467Hastings Stephen J · Palmer, AKBuilt 1968 · S/N 15069324 N50471Honsperger Karl J Trustee · Fremont, OHBuilt 1968 · S/N 15069327 N50473Cobrinik Adam · Whites Creek, TNBuilt 1968 · S/N 15069329 N50474Mother Lode Flying Club · San Andreas, CABuilt 1968 · S/N 15069330 N50475Mc Ironworks Welding And Fabrication Inc · Chico, CABuilt 1968 · S/N 15069331 N50488Fratti Robert B · Nampa, IDBuilt 1968 · S/N 15069340

Back to Cessna 150J