Skip to content

Registered aircraft · 188

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

N6555XViera Fernando Jr · Asbury, MOBuilt 1960 · S/N 57555 N6557XYarnell Bruce W · Stockton, MOBuilt 1960 · S/N 57557 N6909Mcgrew Aaron · Bremen, GABuilt 1958 · S/N 57514 N69RLLivingston Robin L · Vail, AZBuilt 1960 · S/N 57287 N70TCTwo Ten Bravo Delta LLC · Kaiser, MOBuilt 1977 · S/N 21061707 N711ZGHutton Mark B · Denison, TXS/N 21061817 N7327ELarsen James M · Santa Rosa, CABuilt 1959 · S/N 57027 N7340EStoberski John J · Henderson, NVBuilt 1959 · S/N 57040 N7343ELemanski Joseph S · Grosse Ile, MIBuilt 1959 · S/N 57043 N7350EMuszynski Jerry · Huntington Beach, CABuilt 1959 · S/N 57050 N7352ELandgraf James P Trustee · Camas, WABuilt 1960 · S/N 57052 N7353EFitzpatrick Michael H · Anchorage, AKBuilt 1959 · S/N 57053 N7356EJouppi Kenneth J · Ward Cove, AKBuilt 1959 · S/N 57056 N735FViolette Charles H · Alto, NMBuilt 1959 · S/N 57005 N735SDavis Brady L · Monument, COBuilt 1959 · S/N 57013 N7360EShacklette Donald J · Smiths Grove, KYBuilt 1960 · S/N 57060 N7364EGreat Commission United · Montague, MIBuilt 1960 · S/N 57064 N7366EZarko David S · Fenton, MIBuilt 1960 · S/N 57066 N7373EQuist Donald G · Ridgecrest, CABuilt 1960 · S/N 57073 N7381EDill Terry L · Delphi, INBuilt 1960 · S/N 57081 N7385EGibson Gregory T · Ivel, KYS/N 57085 N7386ESwensen Nathan E · Winnemucca, NVS/N 57086 N7389EWeber James D · Benton City, WABuilt 1960 · S/N 57089 N7393ECardenas Christian · Saint Augustine, FLBuilt 1960 · S/N 57093 N7395ERegistered aircraftBuilt 1959 · S/N 57095 N7398EGriffith John M · Seatac, WABuilt 1960 · S/N 57098 N7399ETenney Curtis J · Sevierville, TNBuilt 1960 · S/N 57099 N7401ECosta Air Service LLC · Painted Post, NYBuilt 1959 · S/N 57101 N7409EDavis Julius E · Theodore, ALS/N 57109 N740BBellas Business LLC · Kalispell, MTS/N 57282 N7410EFerguson Thomas H · Springfield, MOBuilt 1960 · S/N 57110 N7411ERenshaw Elliott · Lavernia, TXBuilt 1960 · S/N 57111 N7412ELorraine Aviation LLC · Lewes, DEBuilt 1960 · S/N 57112 N7425EYoung James Steele · San Diego, CABuilt 1960 · S/N 57125 N7430EBallesteros Irlena · Glendale, CAS/N 57130 N7431EGeyer Austin D · Minot, NDS/N 57131 N7436EFreedom Airforce · Albuquerque, NMBuilt 1960 · S/N 57136 N7438EWalker Jim O · Lovell, WYBuilt 1960 · S/N 57138 N7440EWilson Colton M · Wellsville, UTS/N 57140 N7445EElite Aircraft Sales LLC · Searcy, ARS/N 57145 N7449EDabir-Ebrahimi Mike M · San Mateo, CABuilt 1960 · S/N 57149 N7450EFernald Greg · New River, AZBuilt 1960 · S/N 57150 N7451ETucker Charles M · White City, ORBuilt 1960 · S/N 57151 N7453EMuller Ronald V · Kansas City, MOBuilt 1960 · S/N 57153 N7467EWirfel James K · Shingle Springs, CABuilt 1960 · S/N 57167 N7477EBravo 70 LLC · West Bloomfield, MIS/N 57177 N7483EMerriman David A · Rocklin, CABuilt 1960 · S/N 57183 N7485EJacques Steve C · Centennial, COBuilt 1960 · S/N 57185 N7491EBenscoter Richard S · Nordman, IDBuilt 1960 · S/N 57191 N7497EDunford David R · Maryville, TNBuilt 1960 · S/N 57197

Back to Cessna 210