Skip to content

Registered aircraft · 119

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

N1113BSky Monkey Tailwheels LLC · Richardson, TXBuilt 1947 · S/N 5740 N1115BBradley Lawrence A · Lafayette, CAS/N 5742 N1185BSmith William P · Chandler, OKBuilt 1947 · S/N 5812 N1366BCarter George E · Brownwood, TXS/N 5993 N1372BBorden Lance S · Friendswood, TXBuilt 1948 · S/N 5999 N1374BWidman Robert M · Fairbanks, AKS/N 6001 N1388BSchmid Nathan J · Wilmington, OHBuilt 1948 · S/N 6015 N1392BGrinder Michael C · Fairfield, PABuilt 1948 · S/N 6019 N1411BBowen Haldor S · Sandpoint, IDBuilt 1948 · S/N 6038 N1414BWatson Bobby M · Hoxie, ARBuilt 1948 · S/N 6041 N1425BHicks Jason F · Denver, COBuilt 1948 · S/N 6052 N1430BLutz Terry L · Williamston, MIBuilt 1948 · S/N 6057 N1432BSpurgeon Michael R · Wrightwood, CABuilt 1948 · S/N 6059 N1447BSmith Shawn Benjamin · Salem, ORBuilt 1948 · S/N 6074 N1448BCook David L Trustee · Owasso, OKBuilt 1948 · S/N 6075 N1449BZander Walter W · Glendora, CABuilt 1948 · S/N 6076 N1453BManning Jerry C · Lufkin, TXBuilt 1948 · S/N 6080 N1455BMartin Rand E · Lake Stevens, WAS/N 6082 N1456BGregory Norbert L · Farmington, MNBuilt 1948 · S/N 6083 N1458BPerkins William Barry · Monterey, CABuilt 1948 · S/N 6085 N1459BDavis Jeffrey S · Oregon City, ORBuilt 1948 · S/N 6086 N1474BSanderson David K · Scotts Valley, CABuilt 1948 · S/N 6101 N1480BN1480b LLC · Wentzville, MOBuilt 1948 · S/N 6107 N1490BEspinoza Cheryl · Littleton, COBuilt 1948 · S/N 6117 N1505BKulle William T · Springfield, MABuilt 1948 · S/N 6132 N1512BBradley Larry A · Lafayette, CAS/N 6139 N1544BAdalias Family Farms LLC · Fort Pierce, FLBuilt 1948 · S/N 6171 N1545BMcmullen Morrell E · Angleton, TXBuilt 1948 · S/N 6172 N1553BGurley John A · Dania Beach, FLBuilt 1948 · S/N 6180 N1559BBeierle Michael · Hanover Township, PABuilt 1948 · S/N 6186 N1560BJackson David Clark · Penn Yan, NYBuilt 1948 · S/N 6187 N1594BTinkler Sharon W · Tullahoma, TNBuilt 1948 · S/N 6221 N1674KLa Roche Joseph F · Waukesha, WIBuilt 1946 · S/N 4401 N1817BSlack Jonathan D · Bonfield, ILBuilt 1948 · S/N 6244 N1840BSink Lendon V · Lexington, NCBuilt 1948 · S/N 6267 N1856BWallace Larry W · Millsap, TXS/N 6283 N1865BSly Duane D · Platte, SDBuilt 1957 · S/N 6292 N1866BMorrison William · Nashville, TNBuilt 1948 · S/N 6293 N1871BSensor Paul A · Hampton, IABuilt 1948 · S/N 6298 N1875BWilliams William O · Oswego, ILS/N 6302 N1878BSneed Dana L · Kilgore, TXBuilt 1948 · S/N 6305 N1894BHaynes Elton E · Palestine, TXBuilt 1948 · S/N 6321 N1897BSherrod Robert W Jr · Burleson, TXBuilt 1948 · S/N 6324 N1902BDurham Terry · Parker, COBuilt 1948 · S/N 6329 N1916BScott Olan H · Naples, FLBuilt 1948 · S/N 6343 N1917BCraig Gearhart · Three Rivers, MIS/N 6344 N1918BBauer Ryan K · Quincy, CABuilt 1950 · S/N 6758 N1924BRichards Thomas E · Saint Jo, TXBuilt 1948 · S/N 6351 N1930BVolkmann James P · Bellingham, WAS/N 6357 N1932BKreutzfeld Kenneth F · Marblehead, OHS/N 6359

Back to Luscombe 8F