Skip to content

Piper PA-22-160

Registered aircraft · 456

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

N11BZMetlen Kim · Imbler, ORBuilt 1958 · S/N 22-5715 N123BVInfinity Metalworks Inc · Newton, KSBuilt 1957 · S/N 22-5756 N12TASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1958 · S/N 22-6319 N144JWWarren Joy A · White Lake, MIS/N 22-7286 N162Payne David J · Eagle River, AKBuilt 1957 · S/N 22-5677 N16REFly Pnw LLC · Maple Valley, WAS/N 22-6518 N1797PSherman John · Northport, NYBuilt 1954 · S/N 22-2570 N17PCCarolina Seaplanes LLC · Tega Cay, SCBuilt 1958 · S/N 22-5931 N180DWWilliams J Darrell · Colbert, OKBuilt 1959 · S/N 22-7132 N1958PRush Brendon · Merritt Island, FLBuilt 1958 · S/N 22-6008 N198TPDonnelly Thomas E · Salome, AZBuilt 1957 · S/N 22-5625 N19JCCarney Jerald C · Boise, IDBuilt 1958 · S/N 22-6320 N21PZimmer Katie Lynn · San Antonio, TXBuilt 1958 · S/N 22-6017 N2220KLach Richard · Weldon, CABuilt 1957 · S/N 22-5761 N25TJFerraro Thomas P · Mckinney, TXBuilt 1959 · S/N 22-6676 N2801ZValiair Limited Company Trustee · Casper, WYBuilt 1959 · S/N 22-6794 N2821ZLarson Sidner J · Tucson, AZBuilt 1959 · S/N 22-6826 N2838ZHanrahan Andrew D · Soldotna, AKBuilt 1959 · S/N 22-6833 N2847ZRhodes Jacob H Jr · Lenoir, NCBuilt 1959 · S/N 22-6843 N2849ZAlexander Travis M · Weatherford, TXBuilt 1959 · S/N 22-6845 N2854ZIntermountain Aviation LLC · Missoula, MTBuilt 1959 · S/N 22-6851 N2858ZRoberts Darren T · Vail, AZBuilt 1959 · S/N 22-6855 N2860ZCarter Harold · Elizabethton, TNBuilt 1959 · S/N 22-6857 N2863ZWhitaker Eric L · Detroit, TXS/N 22-6862 N2865ZCrouder Trevor J · Fairbanks, AKBuilt 1959 · S/N 22-6864 N2900ZCheatham Paul · La Verne, CABuilt 1959 · S/N 22-6868 N2914ZEarle Russell John · Reno, NVBuilt 1959 · S/N 22-6884 N2918ZLarson David R · Boerne, TXS/N 22-6888 N2954ZBarkley Terry W · Lakeside, ORBuilt 1959 · S/N 22-6927 N2QHOconnor Lloyd T · Dillingham, AKBuilt 1957 · S/N 22-5780 N3027ZDavis Robert · Wasilla, AKBuilt 1958 · S/N 22-6248 N3028ZDavis Robert L · Wasilla, AKS/N 22-6982 N3029ZSuper 20 LLC · Brandon, SDBuilt 1959 · S/N 22-6983 N3033ZRobertson Scott C · Chappell Hill, TXS/N 22-6987 N3034ZBrown Timothy M · Clyde, OHS/N 22-6988 N3036ZAbell Alan R · Elgin, ILBuilt 1959 · S/N 22-6990 N3038ZFischer Mark D · Hooker, OKBuilt 1959 · S/N 22-6992 N3039ZSvec Adolph R · Marengo, ILBuilt 1959 · S/N 22-6993 N3043ZMaria A Sklar Pa DBA Sklar Law Trustee · Fort Lauderdale, FLBuilt 1959 · S/N 22-6997 N3044ZRoberts Marvin L · Calhoun, GABuilt 1959 · S/N 22-6998 N3045ZColson Douglas J · Emmitsburg, MDBuilt 1959 · S/N 22-6999 N3046ZSzostak Edward M · San Diego, CABuilt 1959 · S/N 22-7000 N3047ZRiffle David T · Woodinville, WABuilt 1960 · S/N 22-7001 N3048ZPalmatier Curt A · Montrose, PABuilt 1959 · S/N 22-7002 N3052ZSummer Aviation LLC · Eden Prairie, MNBuilt 1959 · S/N 22-7006 N3053ZSonntag Franklin T · Stevensville, MDBuilt 1959 · S/N 22-7007 N3054ZSandall Brian E · Lake Stevens, WABuilt 1959 · S/N 22-7008 N3058ZLove Glen L · Poplar Grove, ILBuilt 1959 · S/N 22-7013 N3061ZKell Thomas G · Anchorage, AKS/N 22-7016 N3062ZSchofield Wayne D · Polson, MTBuilt 1959 · S/N 22-7017

Back to Piper PA-22-160