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.

N1522BHetrick Bros Inc · Orovada, NVBuilt 1948 · S/N 6149 N1529BSale Reported · Kennett Square, PASale reportedBuilt 1948 · S/N 6156 N1530BAsleson James E · Intl Falls, MNBuilt 1948 · S/N 6157 N1533BAirpower Museum Inc · Ottumwa, IABuilt 1948 · S/N 6160 N1533KHancheck Paul C · Wadsworth, OHBuilt 1946 · S/N 4260 N1534BMacmahon Ian L · Osteen, FLBuilt 1948 · S/N 6161 N1554BPingston Robert D · Morrice, MIBuilt 1948 · S/N 6181 N1569BLedwith Kenneth E · Lincoln, CABuilt 1948 · S/N 6196 N1572BGallegos Paul A III · Blackfoot, IDBuilt 1948 · S/N 6199 N1573BWeber Joel A · Goddard, KSBuilt 1948 · S/N 6200 N1575KSnodderly Jean · Ward Cove, AKBuilt 1946 · S/N 4302 N1585BCoulter James J · Copperopolis, CABuilt 1948 · S/N 6212 N1585KMcbride David T · Albuquerque, NMBuilt 1946 · S/N 4312 N1594KChandler Robby L · New Hope, ALBuilt 1946 · S/N 4321 N1607KPerdue Sandy L · Asheboro, NCBuilt 1946 · S/N 4334 N1639KGordon Earl S · Custer, SDBuilt 1946 · S/N 4366 N1669KDaphna Inc · Middletown, DEBuilt 1946 · S/N 4396 N1676KYowell Kirby D · Phoenix, AZBuilt 1946 · S/N 4403 N1677KKnutson Chad H · Volga, SDBuilt 1946 · S/N 4404 N1688KHenley Charles D · New London, NCBuilt 1946 · S/N 4415 N1689KChladek Gabriel J · Sisters, ORS/N 4416 N1690KSchreiber Curtis P · Worden, ILS/N 4417 N1712KDethardt James J · Little Chute, WIBuilt 1947 · S/N 4439 N1713KRegistration Pending · Columbia, MORegistration pendingS/N 4440 N1715KHurlburt Ronald V DBA · Durand, WIBuilt 1946 · S/N 4442 N1717KJ Smith Ranch Inc · Condon, ORBuilt 1949 · S/N 4444 N1721KLetkeman John K · Seminole, TXS/N 4448 N1722KKechner Scott · New Hudson, MIBuilt 1946 · S/N 4449 N1733KSogge Bjorn R · Spicer, MNBuilt 1946 · S/N 4460 N1739KBas Part Sales LLC · Greeley, COBuilt 1946 · S/N 4466 N1741KSimply Living LLC · Fort Myers, FLS/N 4468 N1761KGrant Cynthia S · Austin, TXBuilt 1946 · S/N 4488 N1764KMurray Gregory T · Napa, CAS/N 4491 N1765KNesmith Matthew D · Marietta, GABuilt 1946 · S/N 4492 N1767KRegistration Pending · Clancy, MTRegistration pending, pending cancellationS/N 4494 N1770KFlip Turn LLC · Washington, DCBuilt 1946 · S/N 4497 N1773KJasinski Jack J · Necedah, WIBuilt 1946 · S/N 4500 N1776KRodney William Debaun Family Lp · Midlothian, TXS/N 4503 N1778BBrosette Victor N · Dallas, TXBuilt 1948 · S/N 6401 N1784KTony Flies Inc · Sparta, NCS/N 4511 N1786KClemens Ryan · Wasilla, AKBuilt 1946 · S/N 4513 N1793KRegistration Pending · Jupiter, FLRegistration pendingBuilt 1946 · S/N 4520 N1795KNeeser Ryan R · Anchorage, AKBuilt 1946 · S/N 4522 N17UBHannemann James R · Mercer, WIBuilt 1948 · S/N 5947 N1802BRegistered aircraftBuilt 1948 · S/N 6229 N1802KTrofimoff Alexander V · Overland Park, KSS/N 4529 N1803BBorchers Jonathan M · Independence, ORBuilt 1948 · S/N 6230 N1804BLyman John W · Orrs Island, MEBuilt 1948 · S/N 6231 N1805KJohnson Lawrence F · Anchorage, AKBuilt 1947 · S/N 4532 N1806KWells Charles Richard · Hayden, IDS/N 4533

Back to Luscombe 8E