Skip to content

Registered aircraft · 74

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

N1006DObrian Laurence J · Northridge, CAS/N 7614 N1044DMcadam Charles T · Wichita, KSBuilt 1951 · S/N 7656 N1058DMorley Philip · Manhattan Beach, CABuilt 1951 · S/N 7670 N1080DPedron Mathew G · Chico, TXBuilt 1951 · S/N 7692 N1081DMilton William H · Amsterdam, NYBuilt 1951 · S/N 7693 N1401Prestonlines LLC · Wilmington, DEBuilt 1950 · S/N 7540 N1500DMaxson Lee V · Mesa, AZBuilt 1951 · S/N 7722 N1502DPaolucci Christopher J · North Olmsted, OHBuilt 1951 · S/N 7724 N1505DPearce Cedric J · Chapel Hill, NCBuilt 1951 · S/N 7727 N1513DPeile Kelly T · Lakeview, ORBuilt 1951 · S/N 7735 N1515DHolmes John A Trustee · Glen Rose, TXBuilt 1951 · S/N 7737 N1525DHeintz John F · Los Angeles, CABuilt 1952 · S/N 7747 N1535DHorney Paul · Russellville, ARBuilt 1952 · S/N 7757 N1551DSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1952 · S/N 7773 N1904UAircraft Partner Holdings Inc Trustee · BerlinBuilt 1950 · S/N 7592 N190DFFuller Darel C · Moses Lake, WABuilt 1952 · S/N 7786 N190ECMiller Dennis G · Galena, ILBuilt 1951 · S/N 7653 N190LSSkinner Lawrence W · Fort Myers, FLBuilt 1950 · S/N 7542 N190SMelichar Lynn R · Fort Lauderdale, FLS/N 7567 N190VTMarshall Rodney E · Roscoe, ILBuilt 1948 · S/N 7171 N195ABYeoman David D · Bettendorf, IABuilt 1952 · S/N 7794 N195GEThaxton Robert W · Rifle, COS/N 7600 N195PDiamond B Farms Trucking Inc · Gamaliel, KYBuilt 1948 · S/N 7218 N195PWRieke Rhett · Bigfork, MTBuilt 1949 · S/N 7647 N195WLRegistration Pending · Coldwater, MIRegistration pendingS/N 7620 N195XBusinessliner 190 Express LLC · Rogers, MNBuilt 1949 · S/N 7464 N1CZWarden Richard L · Canby, ORBuilt 1950 · S/N 7481 N3004BDirksen Daniel L · Montevideo, MNBuilt 1952 · S/N 7887 N3057BRobins Jack S · Kaysville, UTBuilt 1952 · S/N 7940 N3071BSwing Shift Aviation LLC · Wilmington, DEBuilt 1952 · S/N 7955 N3087BBlilie Dennis L · Walcott, NDS/N 7972 N3098BKirsteatter Todd Paul · Kewaunee, WIBuilt 1952 · S/N 7983 N3099BStallings James K · Alva, OKBuilt 1953 · S/N 7984 N3426VNikolaus Larry · Huntington, WVBuilt 1948 · S/N 7111 N3427VHowker John A · Louisville, KYBuilt 1948 · S/N 7128 N3440VBarrientos Jeri D · Collinsville, OKBuilt 1948 · S/N 7144 N3474VWestern North Carolina Air Museum · Hendersonville, NCBuilt 1948 · S/N 7174 N3499VSponsler William D · St Charles, ILBuilt 1948 · S/N 7203 N3765GGraber Quinten R · Brooksville, MSBuilt 1948 · S/N 7101 N4310VRobertson Nathan M · Acworth, GABuilt 1948 · S/N 7217 N4318NBybee James W · West Jordan, UTBuilt 1948 · S/N 7092 N4323VRhodes John D · Tarzana, CAS/N 7316 N4330NMays Kevin E · West Liberty, KYBuilt 1947 · S/N 7079 N4339VColtrin Christopher S · Schaumburg, ILBuilt 1948 · S/N 7245 N4346VKoberg Lance L · Dallas, GABuilt 1948 · S/N 7273 N4353NEnea Donald J · Thompson, OHBuilt 1947 · S/N 7054 N4366VKopf Edward H Jr · Las Vegas, NVBuilt 1948 · S/N 7281 N4411CBartko Ramon · Pittsburg, TXS/N 7996 N4413CSteele Aviation Inc · Walnut Cove, NCS/N 7998 N4421CLake City Aero Ltd LLC · Grenada, MSBuilt 1953 · S/N 16006

Back to Cessna 190