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.

N1510QOracle Aviation LLC · Omaha, NEBuilt 1971 · S/N 15072810 N1512QGroves Fenton A · Morrisville, NYBuilt 1971 · S/N 15072812 N1514QHudgens Andrew S · Lubbock, TXBuilt 1971 · S/N 15072814 N1515QPalm Springs Air Museum Inc · Palm Springs, CABuilt 1971 · S/N 15072815 N1516QToth John R · Concord, CABuilt 1970 · S/N 15072816 N1518QMidwest Aero Restorations Ltd · Danville, ILBuilt 1971 · S/N 15072818 N1519QRuppert Thomas E · Fairbanks, AKFirst renewal noticeBuilt 1971 · S/N 15072819 N151EGGadis Anthony J · Etiwanda, CABuilt 1973 · S/N 15075402 N151KACook Christopher K · Wintersville, OHBuilt 1971 · S/N 15072494 N1523QKuharske Jeffrey · Groveland, FLS/N 15072823 N1524QAnderson Anton E · Loves Park, ILBuilt 1971 · S/N 15072824 N1526QTurpin George · Maquoketa, IABuilt 1971 · S/N 15072826 N153DACentral Virginia Aviation Inc · North Dinwiddie, VAS/N 15073786 N1546QInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 15072846 N1547QAndersen Cameron T · French Gulch, CABuilt 1971 · S/N 15072847 N1561QWhisper Jet Aviation LLC · Scottsdale, AZS/N 15072861 N1562QFrontjes Richard J · Essexville, MIBuilt 1971 · S/N 15072862 N1566QMexico Missions & Beyond Inc · Harrison, TNS/N 15072866 N156KAXclusive Level Auto Glass LLC · Kissimmee, FLBuilt 1973 · S/N 15074980 N1570QColvin William E · Newberry, FLBuilt 1971 · S/N 15072870 N1572QStenberg Andrea Renee · Edmonds, WAS/N 15072872 N1573QFergeson Matthew C · Dwg, TXBuilt 1971 · S/N 15072873 N1575QKelley Jack T Jr · Linden, NCS/N 15072875 N1578QBrown Carolyn J · West Ossipee, NHBuilt 1971 · S/N 15072878 N1579QChastain Elizabeth A · Saint Louis, MOBuilt 1971 · S/N 15072879 N157KAPhillips David Jj · Orlando, FLS/N 15075210 N1590QHeyde Raymond E · Hernando, FLBuilt 1971 · S/N 15072890 N1591QBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 15072891 N1592QProietto Nicholas Philip · West Grove, PABuilt 1971 · S/N 15072892 N1594QLesniak Myra D · Hillman, MNS/N 15072894 N1599QGonzalez Anthony H · Springfield, ORBuilt 1971 · S/N 15072899 N15SRAllen Rodney · Connellsville, PABuilt 1971 · S/N 15073055 N16003Coats Jeff · Twin Falls, IDBuilt 1972 · S/N 15073402 N16006Lazor Ron E · Middlefield, CTBuilt 1972 · S/N 15073405 N16007Cottrell Alan L · Toano, VAS/N 15073406 N16011Dennis Ronnie Lee · Odessa, FLBuilt 1972 · S/N 15073409 N16012Filasky Joseph J · Aquebogue, NYBuilt 1972 · S/N 15073410 N16015Rodriguez Richard · Indianapolis, INS/N 15073413 N16017Maley Adam W · Shinnston, WVBuilt 1972 · S/N 15073415 N1601QHesse Ginger C · Stacy, MNBuilt 1971 · S/N 15072901 N16026B&R Aircraft LLC · Wadsworth, OHBuilt 1972 · S/N 15073422 N16029Cabrera Ramon F · Guttenberg, NJBuilt 1972 · S/N 15073424 N16033Mccosh Hunter B · Fort Wainwright, AKBuilt 1972 · S/N 15073427 N16042Weaver Peter D · Davis, CABuilt 1972 · S/N 15073434 N16045Dragseth Joseph M · Kenai, AKS/N 15073437 N16046Sky Walker Flight School LLC · Adrian, MIBuilt 1972 · S/N 15073438 N16048Maki Eric · Duncanville, TXBuilt 1972 · S/N 15073440 N16049Hasselbring Ted · Nashville, TNBuilt 1972 · S/N 15073441 N1604QBuck Fifty LLC · Freeport, ILBuilt 1971 · S/N 15072904 N16051Wells Michael Perry · Thompson Falls, MTBuilt 1972 · S/N 15073442

Back to Cessna 150L