Skip to content

Registered aircraft · 513

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

N5432CBarbee James E · Mason Neck, VABuilt 1950 · S/N 19466 N5437CHand Loraine A · Tahlequah, OKBuilt 1950 · S/N 19561 N5444CMathis Ryan B · Madison, ALBuilt 1950 · S/N 19478 N5446CKing Larry R · Knoxville, TNS/N 19480 N5448CBeamer Nicholas J · Yuba City, CABuilt 1950 · S/N 19482 N5452CMaas Barry M · Bothell, WABuilt 1950 · S/N 19486 N5453CHead Laverne E · Ozark, ALBuilt 1950 · S/N 19487 N5455CSnurkowski John V · Laurens, NYBuilt 1950 · S/N 19489 N5459CWatkins George T · Spokane Valley, WABuilt 1950 · S/N 19493 N5464CKlockner Charles R · Waterford, WIBuilt 1950 · S/N 19498 N5465COliphant Donald E · Benbrook, TXBuilt 1950 · S/N 19499 N5466CLewis Elijah J · Luthersville, GABuilt 1950 · S/N 19500 N5474CTrimble Joshua · San Antonio, TXBuilt 1951 · S/N 19508 N5475CChampagne Richard W · Amelia Court House, VABuilt 1950 · S/N 19509 N5477CJohnson John Christian · Coeur D Alene, IDS/N 19511 N5481COneill Mark B · Pinckney, MIBuilt 1950 · S/N 19515 N5486CMorsman Dorman J · Oklahoma City, OKBuilt 1950 · S/N 19520 N5487CRacoon Aviation LLC · San Antonio, TXBuilt 1950 · S/N 19521 N5490CJenkins Dayne Vaughn · Anchorage, AKS/N 19524 N5492CSorensen Bjarne K · Vero Beach, FLBuilt 1950 · S/N 19526 N5493CHetchler Glenn A · Erie, COBuilt 1950 · S/N 19527 N5495CWallace Tracy C · Santa Rosa, CABuilt 1950 · S/N 19529 N5498CKfg Aviation Inc · Huntersville, NCS/N 19602 N5499CJohnson Linzy A · Lake Stevens, WABuilt 1950 · S/N 19533 N5504CLevsen Daniel C · Clarence, IABuilt 1950 · S/N 19538 N5507CAnderson Michael J · Carmichael, CABuilt 1950 · S/N 19541 N5508CDierks Brian R · New Waverly, TXBuilt 1950 · S/N 19542 N5513CLahrman James C · Winter Park, COS/N 19547 N5520CDiamond Andrew · Lake Bluff, ILBuilt 1950 · S/N 19567 N5528CBaum Jeffrey C · Sheridan, WYBuilt 1950 · S/N 19575 N5529CHaralson Stephen K Trustee · Claremore, OKBuilt 1950 · S/N 19576 N5536CWhite Thomas G · Knoxville, PABuilt 1950 · S/N 19583 N5542CPatterson Phillip L · Knoxville, TNBuilt 1950 · S/N 19818 N5543CScott Benge D · Lebanon, ORS/N 19819 N5544CSamoilenko Sergey V · Hillsborough, NCBuilt 1950 · S/N 19820 N5545CJenkins Alfred G · Bangor, MEBuilt 1950 · S/N 19598 N5546CWeinant Michael W Trustee · Fairbanks, AKBuilt 1950 · S/N 19599 N5550CBendickson Roger · Garrison, NDBuilt 1950 · S/N 19603 N5551CAer Kelly LLC · Port Orange, FLBuilt 1950 · S/N 19604 N5552CMcqueary David L · Plant City, FLBuilt 1950 · S/N 19605 N5555CRestel Gregory S · Savannah, GABuilt 1950 · S/N 19608 N5559CFereday Clinton J Jr · Birmingham, MIBuilt 1950 · S/N 19612 N5561CRegistration Pending · Visalia, CARegistration pendingBuilt 1950 · S/N 19614 N5562CCiabattoni James A · Prior Lake, MNBuilt 1950 · S/N 19615 N5567CSchwab Mike · Burnside, ILS/N 19620 N5568CDivietri Nicholas J · Saint Johns, MIBuilt 1950 · S/N 19621 N5570CKilpatrick Brian S · Lumberton, NJBuilt 1950 · S/N 19623 N5573CKelly Rowdy · Mountain Home, ARBuilt 1950 · S/N 19626 N5579CStrope Byron P · Upland, CABuilt 1950 · S/N 19633 N5586CKaras Alyssa J · Henderson, NVBuilt 1950 · S/N 19640

Back to Cessna 170A