Skip to content

Registered aircraft · 435

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

N9810TWall Jeffrey L · Goffstown, NHBuilt 1960 · S/N 47610 N9812TBucks Flight Academy LLC · Cashion, OKS/N 47612 N9813THenley Enterprises Inc · Mangonia Park, FLBuilt 1960 · S/N 47613 N9814TWickizer Stephen W · Knoxville, TNBuilt 1960 · S/N 47614 N9820TSamson Robert C · Waterford, WIBuilt 1960 · S/N 47620 N9824TNeufeld Dwayne A · Coeur D Alene, IDBuilt 1960 · S/N 47624 N9825TLong Duane C · Baskin, LABuilt 1960 · S/N 47625 N9828TArts Donald W · Lincoln, CABuilt 1960 · S/N 47628 N9829TGeske Kenneth A · Thief River Falls, MNBuilt 1960 · S/N 47629 N9830TPoe Joshua J · Peculiar, MOBuilt 1960 · S/N 47630 N9834THulbert Douglas S · Santa Maria, CABuilt 1960 · S/N 47634 N9835TVfr Ltd · Wilmington, DEBuilt 1960 · S/N 47635 N9843TPrzygoda Raymond C · Pinckneyville, ILBuilt 1960 · S/N 47643 N9845TGilbert Lawrence E · Titusville, FLBuilt 1960 · S/N 47645 N9848TMueller Scott A · Garden Prairie, ILBuilt 1960 · S/N 47648 N9849TRushing Kevin W · Marks, MSS/N 47649 N9852TRead Colin L · Plattsburgh, NYBuilt 1960 · S/N 47652 N9854TMcdowell Bryan D · Blooming Grove, TXS/N 47654 N9855TJkc Farm LLC · Chinook, MTBuilt 1960 · S/N 47655 N9857TJones Mark E · Milwaukee, WIS/N 47657 N9858TPollick James J · Frankenmuth, MIBuilt 1960 · S/N 47658 N9859TFox Gary J · Buffalo, NYBuilt 1960 · S/N 47659 N9860THoppers Danny C · Osceola, MOS/N 47660 N9861TMott Joseph · Arvada, COBuilt 1960 · S/N 47661 N9862TGrosgerbauer Bryan · Ogden, UTBuilt 1960 · S/N 47662 N9863TBacklund Scott W · Greybull, WYBuilt 1960 · S/N 47663 N9864TN9864t LLC · Pawleys Island, SCBuilt 1960 · S/N 47664 N9867TClock Kenneth C · Milan, MIBuilt 1960 · S/N 47667 N9869TGoff Joseph L · Kingsland, TXBuilt 1960 · S/N 47669 N9872TSpiker Zachary T · Altoona, ALBuilt 1960 · S/N 47672 N9874TVichy Springs Resort Inc · Ukiah, CABuilt 1960 · S/N 47674 N9877TMarks Ivan A · Newbury Park, CABuilt 1960 · S/N 47677 N9880TCarr Michael J · Murfreesboro, TNFirst renewal noticeBuilt 1960 · S/N 47680 N9891TDunkley Bret Y · Kotzebue, AKS/N 47691 N9898THumphress John A III · Campbellsville, KYS/N 47698

Back to Cessna 172A