Skip to content

Registered aircraft · 1,025

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

N78606Brook Trout Properties LLC DBA · Kalamazoo, MIBuilt 1968 · S/N 17257684 N78622Copeland David Craig Aka · Jackson, GABuilt 1968 · S/N 17257689 N78623Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1968 · S/N 17257690 N78624Dewing Matthew S · Rome, PABuilt 1968 · S/N 17257691 N78626Ycm Solutions Inc · Mechanicsville, VABuilt 1968 · S/N 17257693 N78628Milot John M · Germansville, PABuilt 1968 · S/N 17257694 N78640Glasheen Sean T · Bethel, AKS/N 17257698 N78642Little Falls Pilots Assn Inc · Nisswa, MNBuilt 1968 · S/N 17257699 N78647Twj Aviation 1 LLC · Jacksonville, FLS/N 17257702 N78650Quad Cities Aero LLC · Bettendorf, IABuilt 1968 · S/N 17257704 N78651N78651 LLC · Williamsburg, VABuilt 1968 · S/N 17257705 N78652Manning And Sons Property LLC · Summerville, SCBuilt 1968 · S/N 17257706 N78657Miller David C · Michigan City, INBuilt 1968 · S/N 17257707 N78663Klein Mark P · Ellsworth, KSBuilt 1968 · S/N 17257709 N78668Ames Jimmy M · Collinsville, OKBuilt 1968 · S/N 17257710 N78672Yount Lawrence F · Shelton, WABuilt 1968 · S/N 17257713 N78681Airflyte LLC · Granby, CTBuilt 1968 · S/N 17257718 N78695Mac Electric LLC · White House, TNBuilt 1968 · S/N 17257723 N78710Flying 64th Inc · Oak Ridge, TNBuilt 1968 · S/N 17257726 N78711Swartwood Thomas · Everson, WABuilt 1968 · S/N 17257727 N78716Rhodes Sanford E · Odessa, TXBuilt 1968 · S/N 17257729 N78718Aircraft 1821 LLC · North Charleston, SCS/N 17257731 N78721Aquino Rogelio M · Cliffside Park, NJBuilt 1968 · S/N 17257733 N78729Copper Country Flyers Inc · Oconto, WIBuilt 1968 · S/N 17257736 N78733Garden Spot Flyers · Manheim, PABuilt 1968 · S/N 17257737 N78747Green Matthew M · Turlock, CABuilt 1968 · S/N 17257743 N78757Hooten Bonnie Bryan · Tifton, GABuilt 1968 · S/N 17257748 N78760Jakus Matthew Thomas Trustee · Parowan, UTBuilt 1968 · S/N 17257749 N78766Boyle Dale L · Woodward, OKBuilt 1968 · S/N 17257753 N78785Peck John M · Melrose, MTBuilt 1968 · S/N 17257759 N78789Hooper Dan B · Zanesville, OHBuilt 1968 · S/N 17257761 N78797Allen Stephanie R · Mukilteo, WABuilt 1968 · S/N 17257767 N78799Aerolanding LLC · Enterprise, ALS/N 17257768 N787CPArnett Wallace · Sullivan, INBuilt 1968 · S/N 17257760 N78804Whitt James M · Meadowview, VABuilt 1968 · S/N 17257772 N78805Fugleberg Richard H · Mayville, NDBuilt 1968 · S/N 17257773 N78808Ginter Michael J · Oakland, MDBuilt 1968 · S/N 17257774 N78830Frederick Wayne Schultz · Bradley, ILBuilt 1968 · S/N 17257782 N78834Barron Ted L · Hoover, ALBuilt 1968 · S/N 17257783 N78842Helice Sarcelle LLC · San Antonio, TXBuilt 1968 · S/N 17257787 N78846Aero Investors Lc · Jackson, MIS/N 17257788 N78850Karpik Richard Paul · Grand Rapids, MNBuilt 1968 · S/N 17257790 N78856Bedwell Christopher A · Paso Robles, CABuilt 1968 · S/N 17257791 N78857Hunt Thornton Trevon · Aurora, COBuilt 1968 · S/N 17257792 N78938Wings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 17257794 N78978Martin Gary P · Boonville, MOBuilt 1968 · S/N 17257796 N79000Kemmis Sidney C · Prophetstown, ILBuilt 1968 · S/N 17257797 N79001Pau Hana Enterprises LLC Series IV · Boulder City, NVBuilt 1968 · S/N 17257798 N79002Fremont Aviation Inc · Fremont, NES/N 17257799 N79004Palmer Joe A · Meridian, IDBuilt 1968 · S/N 17257801

Back to Cessna 172K