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.

N1708QJergovich Jack A · Austin, TXBuilt 1971 · S/N 15073008 N17098Lake Michigan Asset Management LLC · Grand Rapids, MIBuilt 1972 · S/N 15073622 N17101Vasquez Juan E · Miami, FLBuilt 1972 · S/N 15073623 N17106Tate Daron D Trustee · Pasco, WABuilt 1972 · S/N 15073627 N1712QMischief Makers LLC · Tuscaloosa, ALBuilt 1971 · S/N 15073012 N17134Trappe Enterprises LLC · Street, MDBuilt 1972 · S/N 15073633 N17136Ireland Brian T · Newberg, ORS/N 15073635 N1713QMaier Brandon · Eagle Grove, IABuilt 1971 · S/N 15073013 N17141Dawson Aircraft Inc · Clinton, ARBuilt 1972 · S/N 15073638 N17143Misner Gear K · Phoenix, AZBuilt 1972 · S/N 15073640 N1714QRoth Mark E · Stevensville, MTBuilt 1971 · S/N 15073014 N17170Cannon Christopher H · Moorpark, CABuilt 1972 · S/N 15073644 N17174Davison Mark L · Vacaville, CAS/N 15073648 N17176Johns Thomas D · West Hills, CABuilt 1972 · S/N 15073649 N17181Hays Jerry W · Heath, TXBuilt 1972 · S/N 15073652 N1718QRegistered aircraftS/N 15073018 N1719QMartinz Mike · Big Timber, MTBuilt 1971 · S/N 15073019 N17200Horton Andrea L · Auburn, CABuilt 1972 · S/N 15073659 N17203Ds Flight Services LLC · Battle Groun, WAS/N 15073662 N17205International Air Services Inc Trustee · Carson City, NVS/N 15073664 N17210Babler Paul W · Blaine, MNBuilt 1972 · S/N 15073666 N17218Papich William · Boston, NYBuilt 1972 · S/N 15073671 N17221Gray Jimmie E · Punta Gorda, FLS/N 15073673 N17230Chase Melissa L · Port Orange, FLBuilt 1972 · S/N 15073679 N1723QScroggy Edward R · Louisville, KYBuilt 1971 · S/N 15073023 N17251Aurora 17 Holdings LLC · Aurora, ORBuilt 1972 · S/N 15073687 N17256Smith Taylor C · Amarillo, TXBuilt 1972 · S/N 15073692 N17257Johnson Ralph R · Roanoke Rapids, NCBuilt 1972 · S/N 15073693 N17258Registered aircraftS/N 15073694 N17260Woodley Aerial Leasing LLC · Walnut, ILS/N 15073696 N17263Medbery Nathan J · Minto, NDS/N 15073698 N17266Stroup Trey C · Fort Pierre, SDS/N 15073701 N17267Munch James L · Aumsville, ORBuilt 1972 · S/N 15073702 N1727QGlobal Flight Training Solutions Inc · Immokalee, FLBuilt 1971 · S/N 15073027 N17291Region Flyers LLC · Valparaiso, INBuilt 1972 · S/N 15073704 N17293Kieren Bryce J · Tucson, AZBuilt 1972 · S/N 15073706 N17295Alaverdi Omeed · California, MDBuilt 1972 · S/N 15073708 N17298Biller Luke A · Milton, DEBuilt 1972 · S/N 15073711 N17299Sale Reported · Mobile, ALSale reportedBuilt 1972 · S/N 15073712 N1735QMadden David · Bethlehem, NHBuilt 1971 · S/N 15073035 N17371Lynch Kyle R · Palmetto, FLBuilt 1972 · S/N 15073714 N17375Jts Aircraft LLC · Rock Hill, SCBuilt 1972 · S/N 15073718 N1737QWilliams Kamille N · Juneau, AKS/N 15073037 N17382Hagelstein Ele C · Sanderson, TXRegistration expired, pending cancellationBuilt 1972 · S/N 15073715 N1747QAleyda Aviation LLC · Berlin, NJBuilt 1972 · S/N 15073047 N1749QScott Andrew F · Beaufort, SCBuilt 1971 · S/N 15073049 N1756QVerhalen John P Jr · Scottsville, TXBuilt 1971 · S/N 15073056 N1768QHarper John T · Fairfield, OHBuilt 1971 · S/N 15073068 N1769QPmn Enterprises LLC · Fremont, WIBuilt 1971 · S/N 15073069 N1775QBrooks Timothy J · Oshkosh, WIS/N 15073075

Back to Cessna 150L