Skip to content

Great Lakes 2T-1A-2

Registered aircraft · 115

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

N101GLAssociated Aircraft LLC · San Diego, CAS/N 0714 N112PTGreat Lakes Bp LLC · Cranston, RIS/N 0808 N12RDoll John M · Austin, TXBuilt 1976 · S/N 0744 N14JVFullen Ronnie E · Seguin, TXBuilt 1977 · S/N 0749 N161GLEdwards Jeffrey L · Port Orange, FLBuilt 1978 · S/N 0814 N16GLDuncan David · Colorado Springs, COS/N 0772 N175HDEdens Kenneth L · Hot Springs, ARBuilt 1975 · S/N 0708 N1XGClass A Coaches LLC · Missoula, MTBuilt 1981 · S/N 1001 N21XGPrivitt Bret · Hudson Oaks, TXBuilt 1982 · S/N 1007 N22LBComchoc Paul R · Bellevue, WABuilt 1976 · S/N 0730 N24CManganaro Andrew J · Xenia, OHBuilt 1985 · S/N 1011 N2XGFrisch John W III · Chicago, ILBuilt 1980 · S/N 0830 N3502LNatale William F · Saratoga Springs, NYBuilt 1978 · S/N 0792 N3511LPatty Brent A · El Dorado, KSBuilt 1978 · S/N 0793 N3513LDuden Brett R · Golden, COBuilt 1978 · S/N 0795 N3514LFlying Horseman Ranch LLC · Stuart, VABuilt 1978 · S/N 0796 N3515LBorchers Bruce A · Scotts Valley, CAS/N 0797 N3544LLabounty Dana G · Sumter, SCBuilt 1978 · S/N 0800 N3554LHarding Nelson · Lebanon, ORBuilt 1978 · S/N 0801 N3564LShepherd William M · Virginia Beach, VABuilt 1978 · S/N 0803 N3567LGordon Robert E Jr · Holly Springs, NCBuilt 1978 · S/N 0805 N3587LVanatta J Dennis · Faribault, MNBuilt 1978 · S/N 0809 N3604LWalker Carol L · Ennis, TXBuilt 1978 · S/N 0812 N3604XJones Bryan David Kingsley · San Diego, CABuilt 1977 · S/N 0767 N3661LAccomazzo Mark E · Charlotte, NCBuilt 1978 · S/N 0816 N3665LBeranek John W · Cascade, IABuilt 1978 · S/N 0817 N3673LM&M Shipshape LLC · Kalispell, MTBuilt 1978 · S/N 0820 N3676LGeantil Thomas G · San Diego, CABuilt 1978 · S/N 0821 N3678LAerojet Services Inc · Aurora, COBuilt 1978 · S/N 0822 N3684LLucke Eva DBA · Minot, NDBuilt 1978 · S/N 0819 N3702FBuzjob Aviation LLC · Los Angeles, CABuilt 1976 · S/N 0739 N3703FPresby Aire LLC · Berlin, NHBuilt 1976 · S/N 0738 N3705FMonteith Andrew W · Lebanon, PABuilt 1977 · S/N 0750 N371PFInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 0743 N3731FCarder Wiley C · Cameron Park, CABuilt 1976 · S/N 0746 N3742FBenson Edward A · San Antonio, TXBuilt 1977 · S/N 0755 N3751FAdrion Advisors Inc · Winter Haven, FLBuilt 1977 · S/N 0756 N3759FCoates Joseph M Jr · Tallapoosa, GABuilt 1977 · S/N 0757 N3763FSmith Herbert L · Brandon, MSBuilt 1977 · S/N 0759 N3765FSalton Robert L · Charlotte, NCBuilt 1977 · S/N 0760 N3771FCrane John R · Niceville, FLS/N 0764 N3775FHickle William H · Inyokern, CABuilt 1977 · S/N 0766 N37WRStill Flying LLC · Carlisle, PABuilt 1975 · S/N 0721 N3800FCampbell Joseph P · Vail, AZBuilt 1977 · S/N 0768 N3803FPiercy Ronald S · Moses Lake, WABuilt 1977 · S/N 0771 N3805FSmith James E Trustee · Kalispell, MTBuilt 1977 · S/N 0773 N3806FSkytours Aerial LLC · Jackson, MIBuilt 1977 · S/N 0774 N3807FDeno Gerald G · Battle Creek, MIBuilt 1977 · S/N 0775 N3808FChandler Air Service Inc · Chandler, AZBuilt 1977 · S/N 0776 N3810FTomco Stores Ltd · Ruidoso, NMBuilt 1977 · S/N 0778

Back to Great Lakes 2T-1A-2