Skip to content

Registered aircraft · 106

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

N1001DSpartan National Holdings LLC · Missoula, MTBuilt 1950 · S/N 7609 N1005DAeronautical Technical Service Inc · Collierville, TNS/N 7613 N1008DRussellaire LLC · Darby, MTBuilt 1950 · S/N 7616 N1009DWelch Thomas R · Modesto, CABuilt 1950 · S/N 7617 N1010DBoggs David · Mesa, AZBuilt 1950 · S/N 7618 N1013DSweeney Sean M · Reunion, FLBuilt 1950 · S/N 7621 N1016DArdizzone Mark R · Mckinney, TXBuilt 1950 · S/N 7624 N1022DSmith Glenn C · University Place, WAS/N 7630 N1032DKilponen Jeffrey G · Irving, TXBuilt 1951 · S/N 7716 N1043DDarr Dennis L · Boron, CABuilt 1951 · S/N 7655 N1053DFisher Evan G · Fort Worth, TXBuilt 1951 · S/N 7665 N1054DBrown Douglas R · Centralia, WABuilt 1951 · S/N 7666 N1056DSmooth Landings LLC · Magee, MSBuilt 1951 · S/N 7668 N1057DMedore Douglas A · Romoland, CAS/N 7669 N1068DReid James D · Thomasville, NCBuilt 1951 · S/N 7680 N1069DPrescott Scot · Alburgh, VTBuilt 1951 · S/N 7681 N1071DWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1951 · S/N 7683 N1072DRegistered aircraftS/N 7684 N1075DBrundage Donald J Jr · Green Cove Springs, FLBuilt 1951 · S/N 7687 N1082DSimonye Curtis F · Holmes Beach, FLBuilt 1951 · S/N 7694 N1092DManns Flying Service Inc · Lubbock, TXBuilt 1951 · S/N 7704 N10NSpring Grove Aviation LLC · Spring Grove, ILBuilt 1951 · S/N 7657 N1514DPort Townsend Aero Museum · Port Townsend, WABuilt 1951 · S/N 7736 N1518DStegman Robert A · Saint Peters, MOBuilt 1951 · S/N 7740 N1524DSmith Richard D II · Luthersville, GABuilt 1952 · S/N 7746 N1528DMcpartland Patrick · Herriman, UTBuilt 1952 · S/N 7750 N1532DShipman Jared K · Bismarck, MOBuilt 1952 · S/N 7754 N1559DDougherty Peter I · Orchard Park, NYBuilt 1952 · S/N 7781 N1560DSasser Christopher G · Ammon, IDS/N 7782 N1567DQualitair LLC Trustee · MichelstadtBuilt 1952 · S/N 7789 N1570DBoswell Kurt R · Renton, WABuilt 1952 · S/N 7792 N1571DMilton William H · West Glenville, NYBuilt 1952 · S/N 7793 N1576DMock Lurita M · Anderson, INBuilt 1952 · S/N 7798 N1591DBrewer George F II · Colorado Springs, COBuilt 1952 · S/N 7874 N166VNLower Columbia River Company LLC · Longview, WABuilt 1950 · S/N 7588 N177WAnderson David R · Sycamore, ILBuilt 1950 · S/N 7642 N195AKLeamon Douglas H Trustee · Stockwell, INBuilt 1952 · S/N 7778 N195CKFischer James E · Lakeville, MNS/N 7515 N195DCGrones John G · Port Orange, FLBuilt 1951 · S/N 7734 N195DKMueller Dale H · Payson, AZBuilt 1950 · S/N 7615 N195DYWheaton Clay D · Orchard Park, NYBuilt 1952 · S/N 7878 N195ELEllingham Jeffrey B · Perry, GABuilt 1953 · S/N 16039 N195FYGarin Alan Thomas · Waxhaw, NCBuilt 1953 · S/N 16050 N195JFDark Ark Enterprises LLC · Bentonville, ARBuilt 1950 · S/N 7576 N195KRKiser Richard K · Grottoes, VABuilt 1948 · S/N 7160 N195KSKalina David A · Johnstown, PABuilt 1950 · S/N 7582 N195LSRicks Aviation Adventures LLC · Grand Forks, NDBuilt 1947 · S/N 7051 N195PRRg Aviation Inc · Wilmington, DEBuilt 1952 · S/N 7871 N195QPlane Fun Inc Tr Trustee · Snellville, GABuilt 1952 · S/N 7743 N195RJJeffries Ronald G · Manson, WAS/N 7899

Back to Cessna 195A