Skip to content

Registered aircraft · 1,447

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

N12JTHines Thomas J · Amsterdam, NYBuilt 1972 · S/N 15073955 N1300QA-Cent Aviation Inc · Jacksonville, FLBuilt 1971 · S/N 15072600 N1302QProfessional Pilot Training Inc · Eagle Lake, TXBuilt 1971 · S/N 15072602 N1303QMontemayor Joshua Lee · Orlando, FLBuilt 1971 · S/N 15072603 N1304MBourg Frederick I · Drummond, WIBuilt 1971 · S/N 15072604 N1305QThomas George E · Marietta, OHBuilt 1971 · S/N 15072605 N1306QCompton Kenneth Dale · Mebane, NCS/N 15072606 N1309QSteenbarger Summer D · Woodland, WAS/N 15072609 N130RVUddin Nazim · Buffalo, NYS/N 15072090 N1315QWhite Beth A · Keene, NHBuilt 1971 · S/N 15072615 N1319QOutman Christopher · Lowell, MIBuilt 1971 · S/N 15072619 N1322QMadden Killian · Worcester, MABuilt 1971 · S/N 15072622 N1326QFreburg Larry D · Omaha, NEBuilt 1971 · S/N 15072626 N1332QMcgrath Robert B · Haiku, HIBuilt 1971 · S/N 15072632 N1335QStaley Julie M · Juneau, AKBuilt 1971 · S/N 15072635 N1337QHarter Timothy W · Waterloo, ILBuilt 1971 · S/N 15072637 N1354QBaker Wayne E · Crossville, TNBuilt 1971 · S/N 15072654 N1357QMckenzie Paul · Stockton, CABuilt 1971 · S/N 15072657 N1358QWilliams Matthew L · Longview, TXBuilt 1971 · S/N 15072658 N1363QAsch John C · Zephyrhills, FLBuilt 1971 · S/N 15072663 N1374QAdams Robert J · Syracuse, NYS/N 15072674 N1376QPaciej Bernard P · Luzerne, PABuilt 1971 · S/N 15072676 N1378QOppegard Nicholas · Eagle River, AKBuilt 1971 · S/N 15072678 N1382QRegistration Pending · Hubbard, OHRegistration pendingBuilt 1971 · S/N 15072682 N1385QRegister Trenton D · Wilmington, NCBuilt 1971 · S/N 15072685 N1386QRegistration Pending · Wasilla, AKRegistration pendingBuilt 1971 · S/N 15072686 N1387QHendricks Adam · Plano, TXBuilt 1971 · S/N 15072687 N1391QPark Derek B · Lyons, GABuilt 1971 · S/N 15072691 N1392QRegistered aircraftBuilt 1971 · S/N 15072692 N1393QBeitel Ronald Lee · Rochester, MNBuilt 1971 · S/N 15072693 N1394QDaugherty Keith C · Venus, PABuilt 1971 · S/N 15072694 N1409QDjz Aviation LLC · Kalispell, MTBuilt 1971 · S/N 15072709 N140MAMindy Limited LLC · Muscatine, IABuilt 1970 · S/N 15072399 N140RWTarara Chad L · Webster, MNBuilt 1973 · S/N 15074478 N1410GSierra-Mike LLC · Springdale, ARS/N 15073205 N1412QOconnor Melanie Faith · Flagler Beach, FLBuilt 1971 · S/N 15072712 N1413QWolf John C · Bethel, PABuilt 1971 · S/N 15072713 N1414QForsman Robert J · Jber, AKBuilt 1971 · S/N 15072714 N1417QSteinke William A · Mount Juliet, TNBuilt 1971 · S/N 15072717 N1420QSweet Sanford L · Tawas City, MIS/N 15072720 N1424QPadilla Cresencio I · Big Spring, TXBuilt 1971 · S/N 15072724 N1426QJr Imaging Logistics Inc · Pasco, WABuilt 1971 · S/N 15072726 N1429QReeves Richard E · Lincoln, NEBuilt 1971 · S/N 15072729 N142EZAttacoa Air LLC · Juneau, AKBuilt 1972 · S/N 15074086 N1430QGearhart Robert H · Three Rivers, MIBuilt 1971 · S/N 15072730 N1435QWeaver G Thomas · Fairbanks, AKBuilt 1971 · S/N 15072735 N1437QPeyton Jerry L · Sebeka, MNBuilt 1971 · S/N 15072737 N143AKLipinski Glen E · Chandler, AZS/N 15074168 N143DKReynolds Terry J · Phoenix, AZS/N 15073020 N1440GSierra-Mike LLC · Springdale, ARS/N 15072955

Back to Cessna 150L