Skip to content

Registered aircraft · 293

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

N3469UAndrews Nathan S · Graham, WABuilt 1963 · S/N 18254869 N3470UThird Loop Partners · Paso Robles, CABuilt 1963 · S/N 18254870 N3476UNelson Robert D · Anchorage, AKBuilt 1963 · S/N 18254876 N3480USoule Clauson D · Cooperstown, NYS/N 18254880 N3481USmith Lowell A · Gresham, ORBuilt 1963 · S/N 18254881 N3482UMitchell Philip T · Moreland, GABuilt 1963 · S/N 18254882 N3483UPool Robert Brooks · Lake Charles, LABuilt 1963 · S/N 18254883 N3486UZhills Pilot LLC · Zephyrhills, FLBuilt 1963 · S/N 18254886 N3487ULawser Ron · Townsend, MTBuilt 1963 · S/N 18254887 N3491UMalchoff Kevin R · Lake View, NYBuilt 1963 · S/N 18254891 N3492UMaligator Air LLC · Missoula, MTBuilt 1963 · S/N 18254892 N3498UVintage Flyers LLC · Easton, PABuilt 1963 · S/N 18254898 N34SRL-Bird LLC · Hood River, ORBuilt 1963 · S/N 18255005 N3501UN3501u LLC · Tulsa, OKBuilt 1963 · S/N 18254901 N3502UStreamline Business Management · Citrus Heights, CAS/N 18254902 N3509UGarrett Robert L · N Richland Hills, TXBuilt 1963 · S/N 18254909 N3512UN3512u LLC · Ruidoso, NMBuilt 1963 · S/N 18254912 N3513UDieck Michael N · Raleigh, NCBuilt 1963 · S/N 18254913 N3515USchettler Patrick J · Garnett, KSS/N 18254915 N3517UAddison Robert M · Fort Sumner, NMBuilt 1963 · S/N 18254917 N3520USchioppo Joseph · Boynton Beach, FLBuilt 1963 · S/N 18254920 N3522UDfs · Bountiful, UTBuilt 1963 · S/N 18254922 N3523UCharlson Aaron H Jr · Forest City, IABuilt 1963 · S/N 18254923 N3524UHudson George R · Hueytown, ALBuilt 1963 · S/N 18254924 N3526UThomason Tommy Eugene Trustee · Scottsdale, AZBuilt 1963 · S/N 18254926 N3527YHrobak Robert F · Winter Garden, FLBuilt 1963 · S/N 18254427 N3530UKalmbach Justin J · Polson, MTBuilt 1963 · S/N 18254930 N3530YScollon Brian F · Hudson, COBuilt 1962 · S/N 18254430 N3531YPetter David · Stuttgart, ARBuilt 1962 · S/N 18254431 N3532LPiab Inc DBA · Fresno, CAS/N 18254932 N3533YFarley Sean D · Anchorage, AKBuilt 1962 · S/N 18254433 N3537YCaton Robert M · Stafford, VABuilt 1963 · S/N 18254437 N3538UVan Bilsen Aero LLC · Boise, IDBuilt 1963 · S/N 18254938 N3540YAero Leasing LLC · Rapid City, SDBuilt 1962 · S/N 18254440 N3542UChristensen Paul · Granite Falls, WABuilt 1963 · S/N 18254942 N3542YNash Richard P · Missoula, MTBuilt 1962 · S/N 18254442 N3544UKarmik Aviation LLC · Fort Edward, NYS/N 18254944 N3544YPeters Ben · Seminole, TXBuilt 1962 · S/N 18254444 N3547UPanhandle Aviation LLC · Thatcher, AZBuilt 1963 · S/N 18254947 N3547YS & W Aviation LLC · Saint Peters, MOBuilt 1962 · S/N 18254447 N3549UKimble Bryant Shane · Hinton, OKS/N 18254949 N3549YTimuuu Inc · Alden, NYBuilt 1962 · S/N 18254449 N3550UYoung Mary J D · Waynesville, OHBuilt 1963 · S/N 18254950 N3550YForman Barnes LLC · Nampa, IDBuilt 1962 · S/N 18254450 N3551UFallini Anna M · Tonopah, NVBuilt 1963 · S/N 18254951 N3551YWethered Dvm LLC · Boise, IDBuilt 1962 · S/N 18254451 N3553YMiller Jaime W · Deer Park, NYS/N 18254453 N3556YLodestar Aviation LLC · Mooresville, NCBuilt 1962 · S/N 18254456 N3558YRegistered aircraftS/N 18254458 N3560UMcmaster John F · Wichita, KSBuilt 1963 · S/N 18254960

Back to Cessna 182F