Skip to content

Registered aircraft · 660

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

N4257NTurnage Brody G · Weatherford, TXBuilt 1947 · S/N 13728 N4262NCapps Steve · Newcastle, OKBuilt 1947 · S/N 13733 N4266NBischof Timothy C · Port Orange, FLBuilt 1947 · S/N 13737 N4267NClark William M · Ann Arbor, MIBuilt 1947 · S/N 13738 N4276NWilliams Robert B · Bullard, TXS/N 13747 N4286NSteffen Jeffrey W · Crofton, NEBuilt 1947 · S/N 13757 N4292NRegistered aircraftBuilt 1947 · S/N 13763 N44BMClark Dennis L · Ozona, TXBuilt 1947 · S/N 12770 N44DHShore Gerry · Inez, TXBuilt 1946 · S/N 12050 N48120Trzcinski Douglas R · Chesapeake, VABuilt 1948 · S/N 14339 N508JMMunday Jeffrey R Trustee · Waverly, GABuilt 1946 · S/N 8962 N5253DKelley Kenneth R · Reno, NVS/N 13638 N530SZRegistered aircraftBuilt 1946 · S/N 8574 N547ETBarksdale William S · Pascagoula, MSBuilt 1947 · S/N 13803 N54JGKong Trudith A · Auburn, WABuilt 1947 · S/N 13079 N57NDelash John M · Williamson, GABuilt 1946 · S/N 11996 N6208FJones Eric A · Colfax, WAS/N 13257 N62643Leo Stephen Michael · Henrico, VAS/N 12129 N630SAAnglin Marvin D Jr · Alpharetta, GAS/N 10502 N7086QKinney Christopher G · Beresford, SDS/N 11294 N719XJohnson Douglas · Coleraine, MNS/N 11010 N71ZKKlinger Keith · Groveland, FLBuilt 1947 · S/N 13103 N72101Tango Thirty One Aero Clube Inc · Mckinney, TXBuilt 1946 · S/N 9266 N72105Williams Steve C · Elgin, SCS/N 9270 N72123Dowell George B · Dayton, OHBuilt 1946 · S/N 9290 N72135Tropic Aviation Services Inc · Indiantown, FLS/N 9302 N72139Walton T Michael · Hudson Falls, NYS/N 9306 N72155Bradford Andrew Jason · Spokane, WAS/N 9322 N72163Cota Mark · Jaffrey, NHBuilt 1946 · S/N 9330 N72169Miller Dennis R · Denton, TXBuilt 1946 · S/N 9338 N72173Parker Thomas E · Capitola, CABuilt 1946 · S/N 9342 N72185Glauser Matthew I · Magna, UTFirst renewal noticeBuilt 1946 · S/N 9354 N72189Kelly John C · Orting, WABuilt 1946 · S/N 9362 N72201Hill Shawn A · Eloy, AZFirst renewal noticeBuilt 1946 · S/N 9374 N72221Severson Robert T · Edmonds, WABuilt 1946 · S/N 9394 N72237Registration Pending · Corona, CARegistration pendingBuilt 1946 · S/N 9410 N72245Madland Patrick S · Anchorage, AKS/N 9418 N72248Mulhearn Walter Ftrustee · Conroe, TXBuilt 1946 · S/N 9422 N72256Cober Jason M · Johns Island, SCBuilt 1946 · S/N 9430 N72273Triplett B A · Hope, RIBuilt 1946 · S/N 9450 N72305Pratt Carter J · Dover Foxcroft, MES/N 9482 N72318Olson Thomas L · Woodville, WIBuilt 1946 · S/N 9498 N72338Mroz Kaitlin J · Haslet, TXBuilt 1946 · S/N 9522 N72350Beihold Paul D · Carmel, INBuilt 1946 · S/N 9534 N72354Roth Douglas D · Axtell, NES/N 9538 N72360Dellacort Laura J Trustee · Palo Cedro, CABuilt 1946 · S/N 9546 N72368Meech Charles G · Tampa, FLBuilt 1946 · S/N 9554 N72425Grant James L · Cameron Park, CABuilt 1946 · S/N 9586 N72433Moore Jarrel D · Waelder, TXBuilt 1946 · S/N 9598 N72441Michael Kenneth L · Omaha, NEBuilt 1946 · S/N 9606

Back to Cessna 120