Skip to content

Registered aircraft · 91

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

N1045LBernard Robert J · Millbury, MABuilt 1974 · S/N 638 N1048LSparrow Thomas E · Hawley, MNBuilt 1974 · S/N 641 N104PKKreuter Paul E · Goshen, INBuilt 1974 · S/N 639 N1056LFahey Christopher S · Denton, MDBuilt 1974 · S/N 649 N1058LArnote Jeff · Fort Worth, TXBuilt 1974 · S/N 651 N1059LPlanes & Parts Inc · Weston, FLS/N 652 N1066LMensing Roger G III · Sarasota, FLBuilt 1975 · S/N 659 N1068LThompson Equipment Co · New Orleans, LABuilt 1975 · S/N 661 N1070LWilliams Barret G · Homer, AKS/N 663 N1071LGrand Seaplanes LLC · Broken Arrow, OKBuilt 1975 · S/N 664 N1072LTorres Ramon Armando · Mulberry, FLS/N 665 N1073LDesert Fish Aviation LLC · Queen Creek, AZBuilt 1975 · S/N 666 N1075LElsner Henry J · Greensboro, NCBuilt 1975 · S/N 668 N1079LTradewinds Aero Group LLC · Sarasota, FLBuilt 1975 · S/N 672 N111TYDolan John C · Sequim, WAS/N 468 N13RZBjornstad Eugene N Trustee · Girdwood, AKBuilt 1989 · S/N 570 N161LMays Stephen W · Carson City, NVBuilt 1971 · S/N 470 N16RCLake N16rc Partners LLC · Stamford, CTBuilt 1973 · S/N 576 N18NBShapiro David · Anchorage, AKBuilt 1975 · S/N 660 N225EXStrenger Thorsten · Orlando, FLS/N 799 N238RTTorres Ramon A · Mulberry, FLBuilt 1972 · S/N 506 N26133Aerotechniques LLC · South Kent, CTBuilt 1971 · S/N 460 N2872COren David D · Lino Lakes, MNBuilt 1975 · S/N 684 N2MEWayman Luy LLC · Weston, FLS/N 501 N2TYUridel Douglas DBA · Leesburg, FLS/N 451 N2UYLife Builders International · Grand Rapids, MNBuilt 1975 · S/N 685 N337XP3 Points LLC · Comstock Park, MIS/N 736 N34LRanney Jeffrey A · Princeton, MNBuilt 1972 · S/N 537 N35HMMezrah Realty Corp Inc · Tampa, FLBuilt 1983 · S/N 1075 N39362Sport Aviation Services LLC · Lucedale, MSBuilt 1972 · S/N 519 N39387Registration Pending · Post Falls, IDRegistration pendingBuilt 1972 · S/N 536 N396CBReissiger Robert B · Foley, ALBuilt 1973 · S/N 563 N39787Karman William Neal · Lake Stevens, WABuilt 1973 · S/N 551 N39789Ahlhorn Travis · San Marcos, TXS/N 553 N39791Mcmullen Albert J · Corsicana, TXBuilt 1973 · S/N 555 N3RQAir Carriage Inc · Chico, CABuilt 1972 · S/N 523 N406DEAshby Roland · Grand Haven, MIS/N 487 N40CLPowell Sherman B · Pulaski, TNBuilt 1974 · S/N 653 N4200Burdick Rich · Montrose, COBuilt 1975 · S/N 674 N4333Qualitair LLC · MichelstadtBuilt 1972 · S/N 565 N48XBecker Lawrence D · Anacortes, WABuilt 1973 · S/N 560 N4VZDiscovery Aviation LLC · Kalispell, MTBuilt 1975 · S/N 673 N5006LSpanier Mark L · Mcgregor, MNS/N 463 N5023LIsland Hoppers Seaplanes 2 LLC · Orlando, FLBuilt 1971 · S/N 480 N5028LBarla Joel · Eaton Rapids, MIBuilt 1971 · S/N 485 N5035LSteinbauer Timothy · Sandusky, OHBuilt 1971 · S/N 492 N5038LStopher Patrick K · Anchorage, AKS/N 495 N5056LLemon Richard A · Middleton, WIBuilt 1972 · S/N 512 N5059LAeromarine Airways Corp · Miami, FLBuilt 1972 · S/N 515 N51LKKroloff Logan · Seattle, WABuilt 1975 · S/N 662

Back to Lake LA-4-200