Skip to content

Registered aircraft · 326

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

N2628KBraun Elizabeth A · Charleston, SCBuilt 1947 · S/N 5355 N2638KBolin William E · Wooster, OHS/N 5365 N2644KMcginley Corporation Inc · Port Orange, FLBuilt 1947 · S/N 5371 N2651KRegistration Pending · Camden, SCRegistration pendingBuilt 1947 · S/N 5378 N2653KRedd Alan E · Sacramento, CABuilt 1947 · S/N 5380 N2660KKienholz Lisa F · Los Angeles, CABuilt 1947 · S/N 5387 N2661KWalton T Michael · Hudson Falls, NYS/N 5388 N2669KSherman Joseph R · Rio Rancho, NMBuilt 1947 · S/N 5396 N2672KHoward David D · Winner, SDBuilt 1947 · S/N 5399 N2680KLill Stephen P · Lafayette, LABuilt 1947 · S/N 5407 N2690KGaines Robert · Brighton, COS/N 5417 N2692KBoland John M · Oceanport, NJBuilt 1947 · S/N 5419 N2694KWinkelman Walter T · Sullivan, WIBuilt 1947 · S/N 5421 N2701KWoelbing Aviation LLC · Franksville, WIBuilt 1947 · S/N 5428 N2721KTibbitts Constance B · Marble Canyon, AZBuilt 1947 · S/N 5448 N2722KN2722k LLC · Austin, TXBuilt 1947 · S/N 5449 N2759KOtt Edward C · Walnut Creek, CAS/N 5486 N2765KVance Scott R · Calverton, NYBuilt 1947 · S/N 5492 N2767KRegistered aircraftBuilt 1947 · S/N 5494 N2775KSanders Brian L · Tehachapi, CABuilt 1947 · S/N 5502 N2778KDeloach Albert D · Del Valle, TXBuilt 1947 · S/N 5505 N2781KAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1947 · S/N 5508 N2789KColvin Clu D DBA · Big Cabin, OKBuilt 1947 · S/N 5516 N2790KThomson James W · Narragansett, RIBuilt 1947 · S/N 5517 N27RDWengerd Lavern W · Heron, MTBuilt 1946 · S/N 3969 N2826KFallbrook Air Service Inc · Fallbrook, CABuilt 1947 · S/N 5553 N2832KBalogh Andrew · Wellington, FLFirst renewal noticeBuilt 1947 · S/N 5559 N28547Shaw Kevin R · Canton, GABuilt 1940 · S/N 1376 N28612Jackson James E · Brainerd, MNBuilt 1940 · S/N 1441 N28783Huffine Stephen W · Ketchikan, AKBuilt 1940 · S/N 1544 N2921KDenney Brent A · Fowler, COFirst renewal noticeBuilt 1947 · S/N 5648 N2925KMurray Gregory T · Napa, CAFirst renewal noticeBuilt 1947 · S/N 5652 N2933KSciolla Christopher M · Lumberton, NJBuilt 1947 · S/N 5660 N2951KJacobs John Henry · Fairfield, OHS/N 5678 N2953KAkin Mark P · Edgewood, KYBuilt 1947 · S/N 5680 N2993KLee Robert E · Medford, WIBuilt 1947 · S/N 5720 N30448Jackson James E · Brainerd, MNBuilt 1945 · S/N 1926 N37087White Paul M · Elizaville, NYBuilt 1941 · S/N 1748 N373CSCook Kyle H · Newberry, FLBuilt 1946 · S/N 4524 N37GHAckland Gordon S · Frederick, MDBuilt 1947 · S/N 4683 N39067Miller Rondo T · Coon Rapids, MNBuilt 1941 · S/N 1828 N411DEdwards Anthony C · Weaverville, CABuilt 1939 · S/N 947 N41944Karnaukh Mikhail B · West Jefferson, NCBuilt 1941 · S/N 1905 N45565Puzio Joseph E · Butler, TNS/N 2092 N45732Registration Pending · Plains, MTRegistration pendingBuilt 1946 · S/N 2259 N45767Weber Loren B · Virginia Beach, VAS/N 2294 N45804Registered aircraftAssigned, pending cancellationS/N 2331 N45911Lee Ronald C · Bronwood, GABuilt 1946 · S/N 2438 N45925Farrell Jack P · Salem, ORS/N 2452 N47FVVyfvinkel Frederick J · New Smyrna Beach, FLBuilt 1947 · S/N 5504

Back to Luscombe 8E