Skip to content

Registered aircraft · 897

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 ('8190104', '8190111')
  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 ('8190104', '8190111')
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.

N28601Williford Alicia · Terlingua, TXBuilt 1940 · S/N 1430 N28628Boyette Robert J · Meridian, IDBuilt 1940 · S/N 1457 N2867KRamin Jeanette J Executor · Houston, TXBuilt 1947 · S/N 5594 N28701Knight Robert T Sr · Baton Rouge, LAS/N 1462 N28716Davis James R Trustee · Springfield, ORBuilt 1940 · S/N 1477 N28729Davis Ted E · Brodhead, WIBuilt 1940 · S/N 1490 N28731Bohlander Michael S · Marengo, ILBuilt 1940 · S/N 1492 N28784Dubbert Roger D · Mexico, MOBuilt 1940 · S/N 1545 N28789Freudenberg Joseph B · Almira, WAS/N 1550 N28798Flying A Aviation LLC · Archer City, TXBuilt 1940 · S/N 1559 N28823Wilkie David J · Nashua, NHS/N 1565 N28824Labbee Tyler J · White Swan, WABuilt 1940 · S/N 1566 N28826Archibald William B · Hollis, NHBuilt 1940 · S/N 1568 N28841Sword Scott B · Sublimity, ORBuilt 1940 · S/N 1583 N28864Magnuson Lloyd W · Opelousas, LABuilt 1940 · S/N 1606 N28868Schoen David H · Plain, WIBuilt 1940 · S/N 1610 N2889KBarber Gregory A · Farmersville, TXBuilt 1947 · S/N 5616 N28916Carnegie Scott W Trustee · Saint Charles, MOBuilt 1941 · S/N 1658 N2893KRossman Robert L · Crested Butte, COBuilt 1947 · S/N 5620 N2894KYost Alfred R · South Bend, INBuilt 1947 · S/N 5621 N2900KHenning Karl L · Burr Ridge, ILBuilt 1947 · S/N 5627 N2908KBinns Jeffrey E · Hackettstown, NJS/N 5635 N2915KFifer Logan J · Sycamore, ILBuilt 1947 · S/N 5642 N2935KMataro Craig H · Justin, TXBuilt 1947 · S/N 5662 N2942KCuvar Philip M · Granite City, ILS/N 5669 N2943KDurke Raimund · Ben Wheeler, TXBuilt 1947 · S/N 5670 N2944KHodges James M Jr · Manchester, GABuilt 1947 · S/N 5671 N2952KCloudbase Assets Ltd · Avon Lake, OHBuilt 1947 · S/N 5679 N2955KCoulson Michael D · Zanesville, OHBuilt 1947 · S/N 5682 N2956KSterner Robert E · Kettle Falls, WABuilt 1947 · S/N 5683 N2962KUniversity Flying Club Inc · Stevens Point, WIBuilt 1947 · S/N 5689 N2967KDittmann William H · Palmetto, FLBuilt 1947 · S/N 5694 N2969KAdsit David W · Huntsville, ALBuilt 1947 · S/N 5696 N2971KHarmacinski Ilse Trustee · Punta Gorda, FLBuilt 1947 · S/N 5698 N2972KPerry Carlton L · Mount Morris, NYBuilt 1947 · S/N 5700 N2980KKubik Rodrick D · Waterloo, IABuilt 1947 · S/N 5707 N2984KClark George R · Berryton, KSBuilt 1947 · S/N 5711 N2992KWhetzel Herbert H · Clarkesville, GABuilt 1947 · S/N 5719 N311BKFlattum Steven II · Algonquin, ILBuilt 1946 · S/N 3261 N311PMurphy Frank · Thomasville, GABuilt 1940 · S/N 1479 N346YEakin Shawn M · Franklin, PAS/N 2262 N37014Golden Age Aviation LLC · Naperville, ILBuilt 1941 · S/N 1675 N37024Townsend Kim · Manor, TXS/N 1685 N37028Monson Todd J · Lemon Cove, CABuilt 1941 · S/N 1689 N37034Schafer Aircraft Holding LLC · Mesa, AZS/N 1695 N37036Shank Ronald D · Greensburg, KSS/N 1697 N37038Hilbert Elroy E II · Rockford, ILBuilt 1941 · S/N 1699 N37055Schneck Terry A · Slatington, PABuilt 1941 · S/N 1716 N37067Collins Glenn D · Rustburg, VABuilt 1941 · S/N 1728 N37081Jones Raphael S Jr · San Jose, CABuilt 1941 · S/N 1742

Back to Luscombe 8A