Skip to content

Registered aircraft · 1,446

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.

N16243Como Jerry Wayne · Murfreesboro, TNBuilt 1972 · S/N 15073567 N1625QRegistration Pending · Powell, TNRegistration pendingS/N 15072925 N1627QSky Time LLC · Fort Lauderdale, FLBuilt 1971 · S/N 15072927 N1628QMckeeman Kevin Tee · Abilene, KSBuilt 1971 · S/N 15072928 N162BBAsbery David S · Mt Vernon, ILS/N 15073547 N1638QBeck Michael C · Farmington, CTBuilt 1971 · S/N 15072938 N1642QTochman Andrew J · Avon Lake, OHBuilt 1971 · S/N 15072942 N1644QBell Norman O · Hurlock, MDBuilt 1971 · S/N 15072944 N1646QOwens Wilbur · Rancho Palos Verde, CAS/N 15072946 N1648QPlane Connection LLC · New Bern, NCBuilt 1971 · S/N 15072948 N1653QDust Devil Weekend Warriors LLC · Ridgecrest, CAS/N 15072953 N1658QHis Kingdom Aviation · Nevada, TXS/N 15072958 N1659QFlying Wings Of Lousiana · Denham Springs, LABuilt 1971 · S/N 15072959 N1660QDulitz David E · Webster, SDS/N 15072960 N1663QJohnson Steven · Cheyenne, WYBuilt 1971 · S/N 15072963 N1664QWithrow Steven D · Lubbock, TXBuilt 1971 · S/N 15072964 N1666QRegistration Pending · Plymouth, MNRegistration pendingBuilt 1971 · S/N 15072966 N1668QBrunk Hubert J · Lincoln, NEBuilt 1971 · S/N 15072968 N1669QIvy James E · Alba, TXBuilt 1971 · S/N 15072969 N1671QRegistered aircraftBuilt 1971 · S/N 15072971 N1672QHall Donna L · Pulaski, TNS/N 15072972 N1679QRegistration Pending · Fulton, MSRegistration pendingBuilt 1971 · S/N 15072979 N1680QHanke Kenneth O · Clio, SCBuilt 1971 · S/N 15072980 N1685QMore Right Rudder LLC · Newnan, GABuilt 1971 · S/N 15072985 N1686QJ3 Jets LLC · Bellaire, TXBuilt 1971 · S/N 15072986 N1689QDolphin Aviation Flyers LLC · Stuart, FLBuilt 1971 · S/N 15072989 N1690QAviation Visions · Fernandina Beach, FLBuilt 1971 · S/N 15072990 N1695QJostad Leo D · Bottineau, NDFirst renewal noticeBuilt 1971 · S/N 15072995 N1698QHudson Gregory K · Deming, NMBuilt 1971 · S/N 15072998 N16SHDickinson James C · Haslet, TXBuilt 1972 · S/N 15073404 N17001Shields David A · Saylorsburg, PAS/N 15073572 N17004Depietro Shelley Jo · Olympia, WABuilt 1972 · S/N 15073575 N17009Wight John I · Anchorage, AKBuilt 1972 · S/N 15073578 N1700QAtkinson Jonathan E · Chapmansboro, TNBuilt 1971 · S/N 15073000 N17014Alcorn Paul W · Bay City, MIS/N 15073581 N17016Mika Brian D · Andover, MNBuilt 1972 · S/N 15073583 N17021Fletcher John Guy · Diamondhead, MSS/N 15073587 N1702QStrutzenberg Kent R · Manson, IABuilt 1971 · S/N 15073002 N17033Browning Brad T · Lake Park, MNBuilt 1972 · S/N 150-73594 N17039Davidson Luke H · Gilmer, TXS/N 15073597 N1703QTroutman Noah M · Owensboro, KYBuilt 1971 · S/N 15073003 N17043Coleman Sherod · Houston, TXBuilt 1972 · S/N 15073600 N17045Streichenwein Scott F · Salisbury Mills, NYBuilt 1972 · S/N 15073602 N17047Sickinger Alan W · New Philadelphia, OHBuilt 1972 · S/N 15073604 N17048Myob Group LLC · Ocala, FLBuilt 1972 · S/N 15073605 N17060Jacobsen Lee E · Inchelium, WABuilt 1972 · S/N 15073612 N17065Glaser Donald L Jr · Olive Branch, MSS/N 150-73615 N17069Joyce Michael P · New Kent, VAS/N 15073619 N17077Shehl George William III · Charleston, WVBuilt 1972 · S/N 15073257 N1707QGarcia Jorge A · Ponce, PRBuilt 1971 · S/N 15073007

Back to Cessna 150L