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.

N195RSInternational Air Services Inc Trustee · Carson City, NVBuilt 1950 · S/N 7594 N195STFly4sport LLC · Kasilof, AKBuilt 1950 · S/N 7527 N1LEKingsley Kiman J · Miller, MOBuilt 1951 · S/N 7729 N2187CEnvisage LLC · Virginia Beach, VAS/N 16172 N252BBJagmin Michael · Chicago, ILBuilt 1950 · S/N 7571 N3067BImwalle John N · Batavia, OHBuilt 1952 · S/N 7951 N3074BBohl Howard M · Temecula, CABuilt 1952 · S/N 7958 N3083BBachmann Michael · York, SCBuilt 1952 · S/N 7968 N3170GHolbrook Maslen · Caldwell, IDS/N 7590 N3446VPlane Fun Inc Tr Trustee · Snellville, GAS/N 7136 N3451VPearman Aubum D · Tupelo, MSS/N 7148 N3462VSiefring Sean E · Collierville, TNBuilt 1948 · S/N 7187 N369JJB&B Aviation LLC · Evansville, INBuilt 1950 · S/N 7510 N4306NWesner Robert F · El Reno, OKBuilt 1948 · S/N 7104 N4323NGrant Yeol D · Livermore, CABuilt 1948 · S/N 7086 N4324NLeighton George E · Seattle, WABuilt 1948 · S/N 7085 N4328VLumcavok Aviation 1 Inc · Middletown, DEBuilt 1948 · S/N 7234 N4329NPulver Douglas A · Kenockee, MIBuilt 1947 · S/N 7080 N4336NKrcma William H · Washburn, WIBuilt 1947 · S/N 7073 N4374VBrown Robert A · Peachtree City, GABuilt 1949 · S/N 7289 N4392VKeith Harry E III · Coffeyville, KSFirst renewal noticeBuilt 1949 · S/N 7343 N4401CAsher Mitchell J · Senoia, GABuilt 1952 · S/N 7986 N4402CMclain Daniel E · Baden, PABuilt 1952 · S/N 7987 N4434CNewberg Edgar T · Hector, MNBuilt 1953 · S/N 16019 N4448CSnider Gary · West Des Moines, IABuilt 1953 · S/N 16033 N4476CBoatman C L · La Porte, TXBuilt 1953 · S/N 16060 N450RETurrell James A · Flagstaff, AZBuilt 1953 · S/N 7586 N47KLSee David M · Shady Shores, TXBuilt 1947 · S/N 7053 N515BFDelaware Aviation LLC · Sidney, NYFirst renewal noticeBuilt 1950 · S/N 7526 N5NHower James A · Horseshoe Bay, TXBuilt 1949 · S/N 7356 N714EGajewski Lillia M · Billings, MTBuilt 1947 · S/N 7271 N9303AYaw David Oderkirk Trustee · El Dorado Hills, CABuilt 1949 · S/N 7382 N9324ABoswell Kurt R · Renton, WAS/N 7636 N9325ABarron Aviation LLC · Perry, MOS/N 7404 N9389AClark Christian Benjamin · Denver, COBuilt 1950 · S/N 7468 N9395ARothacker Aviation LLC · Chester Springs, PABuilt 1950 · S/N 7474 N9397ABarron Aviation LLC · Perry, MOBuilt 1950 · S/N 7555 N95UObrien Laurence J · Northridge, CABuilt 1951 · S/N 7714 N9800AB T Aircraft Restorations · Bellevue, WABuilt 1950 · S/N 7557 N9815AReese Steven A · Shoreline, WABuilt 1950 · S/N 7494 N9823ADuke Kay L · Darrouzett, TXBuilt 1951 · S/N 7502 N9828AMitchell Thomas H · Kennewick, WABuilt 1950 · S/N 7507 N9835AMcclain Aviation LLC · Roanoke, TXBuilt 1950 · S/N 7528 N9847ASill Phillip II · New Castle, DEBuilt 1950 · S/N 7559 N9849AWatters James · Dwight, ILBuilt 1950 · S/N 7560 N9855AHawley Richard J · Moultonborough, NHBuilt 1950 · S/N 7548 N9857ALarson Michael D · Erie, COBuilt 1949 · S/N 7550 N9858AHolloway Donald P · Chino Hills, CABuilt 1950 · S/N 7551 N9859ASchmidt Aaron B · Auburn, ALBuilt 1950 · S/N 7552 N9863ACrowley John S Jr · Round Top, TXBuilt 1950 · S/N 7565

Back to Cessna 195A