Skip to content

Registered aircraft · 56

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

N1456NGentile Anthony · Madison, ALS/N 22990 N1578NThibodeaux David J · Anna, TXS/N 23110 N2179JSwanson Michael A · Salisbury, CTBuilt 1957 · S/N 20968 N30932Lowman Patrick D · Sherrills Ford, NCBuilt 1940 · S/N 5216 N32954Semmig Jeffrey C · Oceanside, CABuilt 1940 · S/N 5738 N33555Mcglochlin Bruce A · Tomales, CABuilt 1945 · S/N 14031 N3474NHight Melanie · Washington, DCS/N 22697 N3545NFurnas Jerry W · San Diego, CAS/N 22779 N38170Kisela Andrew J · Troy, MOBuilt 1941 · S/N 6838 N41122Minor James F · Lake Dallas, TXBuilt 1941 · S/N 7769 N41301Klintrin Collectibles LLC · Downers Grove, ILBuilt 1941 · S/N 7955 N42399Reece Rebecca H · San Angelo, TXS/N 14658 N42408Sullivan Robert Jr · Downey, CARegistration revokedBuilt 1945 · S/N 14668 N42456Harrington Robert · Chico, CABuilt 1945 · S/N 14723 N42511Stiletto Airpark LLC · Bertram, TXS/N 14783 N42658Keegel Michael D · Sanford, NCBuilt 1945 · S/N 14952 N426CFSkyraider A1e LLC · Rocky Hill, CTBuilt 1944 · S/N 11717 N48694Klingele Shawn T · Wapato, WABuilt 1943 · S/N 10377 N48947Weiler Jerry J · Port Angeles, WABuilt 1942 · S/N G-182 N523WMBiondich Dennis · Rubicon, WIBuilt 1946 · S/N 22358 N5DHHoudek Dennis E · Roseburg, ORS/N 14299 N62179Marsh Matthew · Newburg, NDS/N 22459 N70130Price John C DBA · Bennington, KSS/N 17108 N70302Horst Aviation LLC · New Holland, PAS/N 17278 N7034HNorris Cathy Joan · Statesville, NCBuilt 1946 · S/N 20278 N70371Taylor Daniel J · Dandridge, TNBuilt 1946 · S/N 17355 N70628Nemeth Lydia · Lexington, KYBuilt 1946 · S/N 17640 N7062HAlacoast Vintage Biplanes LLC · Irvington, ALBuilt 1946 · S/N 20312 N70738Morgan Donald Ray · Fort Payne, ALBuilt 1946 · S/N 17757 N70848Martineli James E · Madras, ORS/N 18225 N70918Almand Todd L · Keller, TXBuilt 1946 · S/N 17944 N70927Grosch Dick D · O'Neill, NEBuilt 1946 · S/N 17954 N71039Stan Lucian M · Sacramento, CAS/N 18060 N7226HSkinner Lawrence W · Fort Myers, FLS/N 20490 N7335HHangar 39 LLC · Culpeper, VABuilt 1946 · S/N 20594 N77532Dinger Jamie L · Aberdeen, SDBuilt 1947 · S/N 22037 N78403Lohr Frederick T · Chestertown, MDBuilt 1947 · S/N 23144 N78416Sands Donald · Lafayette, LAS/N 23157 N8360HRose Richard W · Bend, ORBuilt 1945 · S/N 45-5137 N87939Aerial Banners North Inc · Pembroke Pines, FLS/N 15557 N88037Willke Sue E · Sewickley, PAS/N 15654 N88101Peoples Lawrence R · Louisburg, NCBuilt 1945 · S/N 15276 N88146Patterson David K · Collierville, TNBuilt 1946 · S/N 15763 N88684Epps Charles T · Huntsville, ALBuilt 1946 · S/N 16312 N9095HEmmons John K · Corona, CAS/N 29893 N91965Wallace Randall R · Stamps, ARBuilt 1946 · S/N 16390 N92031Sanchez Joseph · Walnut Grove, CABuilt 1946 · S/N 16464 N92248Spec Raymond G · Crescent, PABuilt 1946 · S/N 16704 N92326Dalsky Mark A · Anchorage, AKBuilt 1946 · S/N 16781 N92355Lam Philip · San Francisco, CABuilt 1946 · S/N 16812

Back to Piper J-3C