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.

N21174Registration Pending · Atlantic Beach, FLRegistration pendingBuilt 1973 · S/N 18261464 N21176Gades Gary A · Montevideo, MNBuilt 1972 · S/N 18261465 N21178Park Rodney D · Boring, ORBuilt 1972 · S/N 18261467 N21179Blakey Tammy S · Arlington, WABuilt 1972 · S/N 18261468 N21181Chef Force One Aviation LLC · Miami Beach, FLBuilt 1972 · S/N 18261470 N21184N21184 LLC · Monticello, MNBuilt 1972 · S/N 18261471 N21189Axxo LLC · Flagstaff, AZBuilt 1972 · S/N 18261473 N21191Schrott Bradley S · Federal Way, WABuilt 1972 · S/N 18261475 N21192Aaa Auto Salvage Inc · High Point, NCBuilt 1972 · S/N 18261476 N21193Krueger Scott M · Salem, SCBuilt 1972 · S/N 18261477 N21196Ashurst Richard J · Westmorland, CABuilt 1972 · S/N 18261478 N211ANCalifornia In Nice Inc · San Jose, CABuilt 1974 · S/N 18263220 N21201Delta Aviation Inc · Monticello, MNBuilt 1972 · S/N 18261481 N21202Diamond David Samuel Trustee · Truckee, CABuilt 1972 · S/N 18261482 N21203Provence Michael D · Fort Worth, TXS/N 18261483 N21205Hodl Partners LLC · Allen, TXBuilt 1972 · S/N 18261485 N21206Baird David W · Kanab, UTBuilt 1972 · S/N 18261486 N21207Burgess John H · Tower, MNS/N 18261487 N21215Van Steenkist Grant · Spokane Valley, WABuilt 1972 · S/N 18261494 N21219Dubose Brian · West YorkshireBuilt 1972 · S/N 18261498 N21224Registration Pending · Brenham, TXRegistration pendingBuilt 1972 · S/N 18261499 N21227Fly21227 LLC · Charleston, WVBuilt 1972 · S/N 18261500 N21230Beggs Construction Inc · Salem, ORBuilt 1972 · S/N 18261502 N21236Gjedde David C · Morristown, TNBuilt 1972 · S/N 18261506 N21238Hatfield Derik L · Mesa, AZBuilt 1972 · S/N 18261508 N21244Connors Geoffrey M · La Center, WABuilt 1972 · S/N 18261512 N21247Registered aircraftBuilt 1972 · S/N 18261515 N21251De La Fuente Rene M Trustee · Yorktown, VABuilt 1972 · S/N 18261518 N21254High Wing 182 LLC · Lenoir City, TNBuilt 1972 · S/N 18261519 N21257Stc Aviation Services LLC · Logan, UTBuilt 1972 · S/N 18261521 N21260Airborne Athletics Inc · Bloomington, MNBuilt 1973 · S/N 18261523 N21268Aufderhar Kenneth G · Lopez Island, WABuilt 1972 · S/N 18261528 N21271Barnett Ryan M · El Reno, OKBuilt 1972 · S/N 18261529 N21274Quax LLC · Wallkill, NYBuilt 1972 · S/N 18261531 N21281Horne Randall W · Millington, TNBuilt 1972 · S/N 18261535 N21291Castleair LLC · Dothan, ALBuilt 1972 · S/N 18261542 N21297Bradley Robert S M Sr · Rougemont, NCBuilt 1972 · S/N 18261545 N212WLPeace Jiles V · Easley, SCBuilt 1976 · S/N 18265082 N21302Blackburn James E · Upland, CAS/N 18261549 N21310Bagnell Enterprises LLC · Anaconda, MTBuilt 1972 · S/N 18261552 N21315Clinical Anatomy Associates Inc · Mason, OHBuilt 1972 · S/N 18261556 N21316Bohnert Jason F · Harrisonville, MOBuilt 1972 · S/N 18261557 N21317Mathes Richard A · Byron, NYBuilt 1972 · S/N 18261558 N21328Endler Harold A · Black Mountain, NCBuilt 1972 · S/N 18261563 N21332Celmer Charles A · Puyallup, WABuilt 1972 · S/N 18261566 N21333Melius Ray D · Erda, UTBuilt 1972 · S/N 18261567 N21338N21338 LLC · Amarillo, TXBuilt 1972 · S/N 18261571 N21343Bulger Thomas R · Oak Harbor, WABuilt 1972 · S/N 18261575 N21344Skylane Therapy LLC · Nampa, IDBuilt 1972 · S/N 18261576 N21348Nri Flying Club Inc · Walnut Creek, CABuilt 1972 · S/N 18261578

Back to Cessna 182P