Skip to content

Registered aircraft · 2,099

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

N52537Chico Cassandra LLC · Chico, CAS/N 18262662 N52544H & H Planting Company · Duncan, MSBuilt 1973 · S/N 18262668 N52554Hermiston Aviation Inc · Hermiston, ORBuilt 1973 · S/N 18262672 N52557Ruby James Edwin Trustee · Hereford, AZBuilt 1973 · S/N 18262674 N52562Sioux Sky Aviation LLC · Grand Forks, NDS/N 18262676 N52563Concord Flying Club Inc · Lafayette, CABuilt 1973 · S/N 18262677 N52564Electrical Systems Professionals Inc · Trinidad, COBuilt 1973 · S/N 18262678 N52572Corrosion Savants LLC · Wilmington, DEBuilt 1973 · S/N 18262683 N52577Hartman Edward L · N Canton, OHBuilt 1973 · S/N 18262684 N52587Mcconal Danny · Seminole, TXBuilt 1973 · S/N 18262690 N52590Aereo Flyers Inc · Camino, CABuilt 1973 · S/N 18262692 N52595Cotton Christopher S · Dallas, TXBuilt 1973 · S/N 18262696 N52607Jse Holdings Inc · Wilmington, DEBuilt 1973 · S/N 18262705 N52608Kaliebe Kyle D · Mount Pleasant, WIBuilt 1973 · S/N 18262706 N52617Land And Sky LLC · Buffalo, MNBuilt 1973 · S/N 18262715 N52620High Risk Ventures Inc · San Diego, CABuilt 1973 · S/N 18262718 N52621Bottieri David P · Mission Viejo, CABuilt 1973 · S/N 18262719 N52624Shrewsbury Roy E II · Daniels, WVBuilt 1973 · S/N 18262721 N52629Mbr Air LLC · Kenosha, WIBuilt 1973 · S/N 18262726 N52674Miller Glenn E Trustee · Albany, ORBuilt 1973 · S/N 18262760 N52677Spencer Joseph T Jr · Felton, CAS/N 18262763 N52681Clough Robert · Woodinville, WABuilt 1973 · S/N 18262766 N52687Abby Enterprises LLC · Plantsville, CTBuilt 1973 · S/N 18262770 N52689Dyberg Mike DBA · Mount Vernon, WABuilt 1973 · S/N 18262771 N52698Marshall Gregory · Farmington, MEBuilt 1973 · S/N 18262779 N526LTCheatum Roger K · Port Orange, FLBuilt 1975 · S/N 18264197 N526UJsrs Holdings LLC · Las Cruces, NMBuilt 1973 · S/N 18262708 N52704Owen John D Trustee · Liberty, MOBuilt 1974 · S/N 18262782 N52707Mook Douglas G · El Paso, TXBuilt 1974 · S/N 18262785 N52714Greager William E · Lakewood, COBuilt 1974 · S/N 18262791 N52726Cottonwood Flyers LLC · Gypsum, COBuilt 1974 · S/N 18262800 N52727Nathaniel Mothershead · Sardis, MSBuilt 1974 · S/N 18262801 N52732Registered aircraftBuilt 1974 · S/N 18262804 N52735Patzoldt Quenton A · Pine City, MNBuilt 1974 · S/N 18262806 N52736Busick Clifford E · Stevenson Ranch, CABuilt 1974 · S/N 18262807 N52739Above All Aviation Inc · Santa Barbara, CABuilt 1974 · S/N 18262810 N52746Kravchenko Aleksandr · Everett, WAS/N 18262815 N52748Hall Howard S · Covington, GABuilt 1974 · S/N 18262816 N52751Weinstein Mark H · Carrollton, GABuilt 1974 · S/N 18262819 N52754Torgerson'S LLC · Ethridge, MTBuilt 1974 · S/N 18262822 N52758Luse David C · Newalla, OKBuilt 1974 · S/N 18262825 N52761Reb Baron Aviation LLC · Riverdale, CAS/N 18262828 N52764Skylane LLC · Williamsburg, VABuilt 1974 · S/N 18262831 N52767Loudy William E · Rigby, IDBuilt 1974 · S/N 18262834 N52775Pa-18 LLC · Hood River, ORBuilt 1974 · S/N 18262837 N52781Mckendry Martin · Carmel Valley, CABuilt 1974 · S/N 18262840 N52783Valdes Alfonso · El Paso, TXBuilt 1974 · S/N 18262842 N52792Ball Richard W · Ridgefield, CTBuilt 1974 · S/N 18262848 N52795Key Lime Consultants LLC · Belleview, FLS/N 18262851 N52797Supinie Andy · Wichita, KSBuilt 1974 · S/N 18262852

Back to Cessna 182P