Skip to content

Registered aircraft · 209

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

N1003DBarron Aviation · Perry, MOBuilt 1950 · S/N 7611 N1015DMickelsen Peter D · Lewistown, MTBuilt 1950 · S/N 7623 N1074DBarron Aviation LLC · Perry, MOBuilt 1951 · S/N 7686 N1077DBarron Aviation LLC · Perry, MOS/N 7689 N1096DDaugherty Lowell E · Adelanto, CAS/N 7720 N1098DDoyle Terry · Grapevine, TXS/N 7710 N126JDEastland Aviation Inc · Midland, TXBuilt 1942 · S/N 7802 N126LCBeylund David L · Macon, GABuilt 1950 · S/N 7632 N126NXCombs Nicholas E · League City, TXBuilt 1951 · S/N 7858 N127DDKimberlin Mark · Grants Pass, ORS/N 7040 N127GMCorn Alley Aviation LLC · El Paso, ILBuilt 1949 · S/N 7411 N13574Warner Aric D · Rosamond, CAS/N 7108 N145VCurrier Susan · Greenvlle Jct, MEBuilt 1948 · S/N 7135 N1533DZimmerman Luke G · Madison, ALBuilt 1952 · S/N 7755 N1538DAdams Richard J · Mesa, AZS/N 7760 N1541DCentral Air Service Inc · Lewistown, MTBuilt 1952 · S/N 7763 N1555DSmith Michael D · North Myrtle Beach, SCBuilt 1952 · S/N 7777 N1558DBelden George B Trustee · Sonoma, CAS/N 7780 N1563DTramontano Jeffrey M · Prosper, TXBuilt 1952 · S/N 7785 N1566DMilton William H · West Glenville, NYBuilt 1952 · S/N 7788 N1569DPlane Fun Inc Tr Trustee · Snellville, GABuilt 1952 · S/N 7791 N1574DWilliams Marc A · Ridgecrest, CABuilt 1952 · S/N 7796 N1577DWilson Travis · Oswego, KSS/N 7799 N1581DChippewa Aero LLC · Montevideo, MNBuilt 1952 · S/N 7864 N174LAltitudes Aircraft Group LLC · Tampa, FLBuilt 1950 · S/N 7539 N177URegistration Pending · Midvale, UTRegistration pendingBuilt 1949 · S/N 7433 N189PSchwartz Stephen R · Goldthwaite, TXBuilt 1950 · S/N 7488 N195AFCarlsbad Raceway Corp · Hemet, CAS/N 7651 N195BBWimbrow Henry J · West Redding, CTBuilt 1947 · S/N 7074 N195BLTower Addison P · Grayslake, ILBuilt 1951 · S/N 7672 N195CGLake City Aero Ltd LLC · Grenada, MSBuilt 1953 · S/N 16120 N195DFDickey Eldon Dewayne · Richmond, TXBuilt 1950 · S/N 7511 N195DMMcguire Dennis B · Howell, MIBuilt 1951 · S/N 7678 N195DRRegistration Pending · Danville, CARegistration pendingBuilt 1949 · S/N 7390 N195DSAbq421 LLC · Los Ranchos, NMBuilt 1948 · S/N 7272 N195DTAlldredge Aviation · Auburn, WABuilt 1948 · S/N 7287 N195FAerostream Services LLC · Cincinnati, OHBuilt 1950 · S/N 7493 N195GSalter Kevin L · Garden City, KSBuilt 1947 · S/N 7047 N195GWRising Jonathan D · Ocala, FLBuilt 1949 · S/N 7455 N195HCalef Jere R Trustee · Mojave, CABuilt 1948 · S/N 7200 N195HADodge Inc · Wilmington, DEBuilt 1965 · S/N 7438 N195JBMoore Glenn C · Elkhart Lake, WIS/N 7220 N195JDBoswell Kurt R · Renton, WAS/N 7603 N195JLLambert James A · Enumclaw, WABuilt 1952 · S/N 7944 N195JPJacobs David E · Saint Georges, DEBuilt 1951 · S/N 7673 N195JSScholl Jonathan W · Mckinney, TXBuilt 1952 · S/N 7872 N195KBHubner Leigh Andrew · Locust Grove, GABuilt 1952 · S/N 7949 N195KJGilbride Richard L · Ringgold, GABuilt 1952 · S/N 7800 N195KWHenkemeyer Joseph S · Cave Creek, AZBuilt 1948 · S/N 7242 N195LBMmm Friemel Inc · Hereford, TXBuilt 1951 · S/N 7703

Back to Cessna 195