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.

N2133KBradford William F · Independence, MOBuilt 1947 · S/N 4860 N2136KCartwright Mark A · Manistique, MIBuilt 1947 · S/N 4863 N2140KWeatherbie Karen S · Centennial, COS/N 4867 N2145KNc2145k LLC · Fremont, OHS/N 4872 N2149KVowell Greg · Coffeyville, KSBuilt 1947 · S/N 4876 N2151KOyster Chris Randell · Bellville, OHBuilt 1947 · S/N 4878 N2158KPachkofsky Donald S · Pleasant Hill, ORBuilt 1947 · S/N 4885 N2170KDykes William F · Laurel, MSBuilt 1947 · S/N 4897 N2171KBeal Gary H · Hyde Park, VTBuilt 1947 · S/N 4898 N2188BCurtis Darrin M · Woodland, CABuilt 1949 · S/N 6615 N2193Kreutzfeld Kenneth F · Marblehead, OHBuilt 1938 · S/N 810 N2193BSmith David Seymour · Los Angeles, CABuilt 1949 · S/N 6620 N2194BBarrett Larry E · Fenton, MIBuilt 1949 · S/N 6621 N2197BRegistration Pending · Toledo, OHRegistration pendingS/N 6624 N21996Sheets Mark W · Cedarburg, WIS/N 3423 N2201KKwasnik Joseph M · Brunswick, MEBuilt 1947 · S/N 4928 N22020Wilder John G · Austin, TXBuilt 1938 · S/N 870 N22023Beyer Jeffrey R · Slinger, WIBuilt 1939 · S/N 873 N2202KDenkins Wayne L · Flushing, MIBuilt 1947 · S/N 4929 N2204KBrem Ronald C · Bakersfield, CABuilt 1947 · S/N 4931 N22051Fenger Paul L · Cottonwood, MNBuilt 1939 · S/N 877 N22052Monaghan Richard C · Lenore, IDBuilt 1939 · S/N 878 N2207KDyer Ben · Cincinnati, OHBuilt 1947 · S/N 4934 N22087Webster David Ht · Columbia, TNBuilt 1939 · S/N 909 N2208KEldridge Andrea E · Donnelly, IDBuilt 1947 · S/N 4935 N22091Shank Ronald D · Greensburg, KSBuilt 1939 · S/N 913 N22098Forbis Greg S · Dewitt, MIBuilt 1939 · S/N 920 N2211KWittstock Duane C · Norwalk, IABuilt 1947 · S/N 4938 N2212KBrown Kristen C · Independence, ORBuilt 1947 · S/N 4939 N2213KJohnson Douglas L · Grass Valley, CAS/N 4940 N2215KHubble Thomas A · Odessa, TXBuilt 1947 · S/N 4942 N2220BDavis David F · Oregon, ILBuilt 1949 · S/N 6647 N2223KLopresti Stephen A · Marlborough, CTBuilt 1947 · S/N 4950 N2227KTraweek Brian C · Battle Mountain, NVBuilt 1947 · S/N 4954 N2229BLaperle James · Greenville, CABuilt 1949 · S/N 6656 N2233KHavens Jonathan D · Thornville, OHBuilt 1947 · S/N 4960 N2234KMagnuson Lloyd W · Opelousas, LABuilt 1947 · S/N 4961 N2235KVanderwal Calvin K · Burbank, SDBuilt 1947 · S/N 4962 N2237BThoresen Brian D · Green Cove Springs, FLS/N 6664 N2239KMagnuson Lloyd N · Opelousas, LABuilt 1947 · S/N 4966 N2251BWilliams Timoty L · Mckinney, TXBuilt 1949 · S/N 6678 N2259KSilvaire Aviation LLC · Danville, INBuilt 1947 · S/N 4986 N2262KWalker Kyle C · Juneau, AKBuilt 1947 · S/N 4989 N2265KStephens Freddy P · Cairo, GAS/N 4992 N2267KSmith Warren D · Oak Harbor, WAS/N 4994 N23000Devney Clarence W III · Omaha, NEBuilt 1939 · S/N 924 N23007Mogavero Marc A · Southport, NCS/N 930 N23008Lugten Jerry L · Leslie, MIBuilt 1939 · S/N 931 N23011Magnuson Lloyd W · Opelousas, LAS/N 934 N23029Kingsley Kevin C · Lamar, MOBuilt 1939 · S/N 952

Back to Luscombe 8A