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.

N58652K L Aircraft LLC · Fort Myers, FLBuilt 1973 · S/N 18262206 N58653Rydman Nathan D · Moab, UTBuilt 1973 · S/N 18262207 N58658Witte Thomas L · Palestine, TXBuilt 1973 · S/N 18262212 N58659Friis Karsten · Oxford, NCBuilt 1973 · S/N 18262213 N58662Vomsaal Frederick S · Columbia, MOBuilt 1973 · S/N 18262216 N58664Hamby Eileen R · Scottsboro, ALBuilt 1973 · S/N 18262218 N58666Brewer Loyd N · Santa Maria, CABuilt 1973 · S/N 18262220 N58673Nawrocki Daniel N · Fairmont, WVBuilt 1973 · S/N 18262226 N58689Reinheimer Robert W · San Francisco, CABuilt 1973 · S/N 18262237 N58691Sonday Terrance P · Spring, TXBuilt 1973 · S/N 18262239 N58693Rychner Glen H · Deer River, MNBuilt 1973 · S/N 18262241 N58701Elsik Dewey D · Georgetown, TXBuilt 1973 · S/N 18262246 N58707Takallu M A · Norfolk, VABuilt 1973 · S/N 18262248 N58714Fun Flying LLC · Wadsworth, OHBuilt 1973 · S/N 18262253 N5871CN5871c LLC · Boulder, COBuilt 1973 · S/N 18262251 N58739Josey Lumber Co Inc · Scotland Neck, NCBuilt 1973 · S/N 18262268 N58742Vaughn Michael R · Summersville, MOBuilt 1973 · S/N 18262269 N58747Martin Robert Daniel · Little Rock, ARBuilt 1973 · S/N 18262272 N58763Downwind LLC · Clancy, MTBuilt 1973 · S/N 18262280 N58766Gonzalez Tomas · Windham, NHBuilt 1973 · S/N 18262282 N58771Casas-Dolz Raul · Dickinson, NDBuilt 1973 · S/N 18262284 N58773Ranchers Skylane LLC · Newcastle, WYBuilt 1973 · S/N 18262286 N58776Wild River Flying Club Inc · Saint Croix Falls, WIBuilt 1973 · S/N 18262288 N58778Bell Bradley J · Searcy, ARBuilt 1973 · S/N 18262290 N58780Sksp LLC · Brandon, FLBuilt 1973 · S/N 18262291 N58790Ego IV Aviation Consulting LLC · Goose Creek, SCBuilt 1973 · S/N 18262295 N58793Summers Randall L · Weslaco, TXBuilt 1973 · S/N 18262298 N58794Lagos Ricardo · Seattle, WABuilt 1973 · S/N 18262299 N58798Tailwind Aviation Holdings LLC · Austin, TXS/N 18262303 N58800S&Hb Sky LLC · Heyburn, IDBuilt 1973 · S/N 18262304 N58812F And L Properties · Magnolia, ARBuilt 1973 · S/N 18262312 N58818Jk Homes LLC · Idaho Falls, IDS/N 18262317 N58821Canipe Rachel B · Shelby, NCBuilt 1973 · S/N 18262319 N58823Silverbullet LLC · San Francisco, CABuilt 1973 · S/N 18262321 N58830Frisbee Ralph · Valley Park, MSBuilt 1973 · S/N 18262326 N58832Wiley Eleven Eleven Ltd · Hayward, WIBuilt 1973 · S/N 18262328 N58843Kcn Aero Club Inc · Overland Park, KSBuilt 1973 · S/N 18262335 N58851Crimm Sam II · Tullahoma, TNBuilt 1973 · S/N 18262342 N58852Backcountry Wagons LLC · Kalispell, MTBuilt 1973 · S/N 18262343 N58853Moulin Neil D · Harrah, OKBuilt 1973 · S/N 18262344 N58859Corby David J · Richmond, MIBuilt 1973 · S/N 18262348 N58860Rentz Jimmy L · Bainbridge, GABuilt 1973 · S/N 18262349 N58865Fairhill Properties LLC · Valley City, NDBuilt 1973 · S/N 18262354 N58866R And M Steel Company · Caldwell, IDBuilt 1973 · S/N 18262355 N58873Carman Steven W · Grass Valley, CABuilt 1973 · S/N 18262362 N58877Executive Flight LLC · Greenwood, MSBuilt 1973 · S/N 18262366 N58882Coburn Shawn · Dos Palos, CABuilt 1973 · S/N 18262371 N58884Snider Aaron A · Ludington, MIBuilt 1973 · S/N 18262373 N58885Livengood John M · Prescott, AZBuilt 1973 · S/N 18262374 N58888Ducommun Robert C · New York, NYBuilt 1973 · S/N 18262377

Back to Cessna 182P