Skip to content

Registered aircraft · 266

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

N46524Barry Mark K · Larimore, NDBuilt 1974 · S/N 18052424 N46535Rugged View Aviation LLC · Condon, MTBuilt 1974 · S/N 18052425 N46563Stephen Iain D · Anchorage, AKBuilt 1974 · S/N 18052427 N46686Skites Ronald W · Salome, AZBuilt 1974 · S/N 18052434 N4887Carroll Daniel G · Magnolia, TXBuilt 1976 · S/N 18052720 N5101YSchrock Marvin J · Sterling, AKS/N 18052550 N52004Jones Steve M · Anchorage, AKBuilt 1974 · S/N 18052437 N52009Sale Reported · Palmer, AKSale reportedBuilt 1974 · S/N 18052438 N52010Bentley John R · Bend, ORS/N 18052439 N52016Lil' Dawg Aviation Inc · Oxford, MSBuilt 1974 · S/N 18052442 N52026Moore Enterprises Leasing Inc · Indianapolis, INS/N 18052448 N52032Briner John T · Celina, TXBuilt 1974 · S/N 18052452 N52035Chancellor J W · Brooksville, MSBuilt 1974 · S/N 18052454 N52051Cutsforth Gary L · Palmer, AKBuilt 1974 · S/N 18052465 N52055Schley James R · Palmer, AKBuilt 1974 · S/N 18052467 N52063Hattenburg Bryce R · Eagle River, AKBuilt 1974 · S/N 18052472 N52065Land Air Enterprises Inc · Boynton Beach, FLBuilt 1974 · S/N 18052474 N52067Rexine Jeffrey A · Chandler, AZBuilt 1974 · S/N 18052476 N52083Gorn Anthony S · Nome, AKBuilt 1974 · S/N 18052488 N52084Lutz Adam R · Kodiak, AKBuilt 1974 · S/N 18052489 N52095Reberry Brian K · Boise, IDBuilt 1974 · S/N 18052496 N52096Lake Pre Mix Inc · Sandpoint, IDBuilt 1974 · S/N 18052497 N52102Duke Kay Lee · Darrouzett, TXBuilt 1974 · S/N 18052501 N52104Oconnor-Ferris Sue Ellen · Wasilla, AKBuilt 1975 · S/N 18052503 N52105Rosendahl Paul O · Ravenna, TXBuilt 1974 · S/N 18052504 N52108Jaworski Roger W · Mesa, AZBuilt 1974 · S/N 18052505 N52112Monette Verne G · Anchorage, AKBuilt 1974 · S/N 18052508 N52130Horton Philip D · Wasilla, AKBuilt 1974 · S/N 18052512 N52134Linden Daniel M · Mcfarland, WIBuilt 1974 · S/N 18052514 N52138Davis Evan A · Wasilla, AKS/N 18052517 N52145Keesecker Joel K · Sweet Home, ORBuilt 1974 · S/N 18052518 N52148Registration Pending · Missoula, MTRegistration pendingBuilt 1974 · S/N 18052519 N52149Meng Christopher J · Dillingham, AKS/N 18052520 N52155Jones Kermit L III · Jasper, ALBuilt 1975 · S/N 18052524 N52158Runyan Pamela J · Raytown, MOBuilt 1974 · S/N 18052526 N52170Blackerby Alexander N · Eola, TXBuilt 1975 · S/N 18052534 N52172Troftgruben Gregory G · Buxton, NDBuilt 1974 · S/N 18052535 N52175Sale Reported · Bangor, MESale reported, pending cancellationBuilt 1974 · S/N 18052538 N52187Monk Robert William · Lake Tomahawk, WIBuilt 1975 · S/N 18052545 N52197Hodges Ray L · Wasilla, AKBuilt 1975 · S/N 18052553 N52199Registered aircraftBuilt 1975 · S/N 18052554 N521JPJpm Flying Service LLC · Marine, ILBuilt 1976 · S/N 18052762 N5284KSmith Nathan C · Kenai, AKBuilt 1975 · S/N 180-52598 N555BLKimberling David L · Lincoln City, ORBuilt 1976 · S/N 18052734 N556WCDassel James T · San Juan Bautista, CAS/N 18052515 N573JFHuddleston Edward L · Oaktown, INBuilt 1973 · S/N 18052398 N601RFPearson Nils C · Englewood, FLBuilt 1975 · S/N 18052560 N604RDSaint Aviation Ministry LLC · Ozark, MOBuilt 1974 · S/N 18052417 N605NBRegistered aircraftBuilt 1976 · S/N 18052732 N623EPApex Aviation LLC · Exeter, NHBuilt 1975 · S/N 18052616

Back to Cessna 180J