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.

N88CZThree Holer LLC · Clayton, GABuilt 1972 · S/N 18261382 N88HQAviation Capital Management LLC · San Jose, CABuilt 1973 · S/N 18262714 N88RBWarner David J · Englewood, OHBuilt 1972 · S/N 18261282 N8BTSwafford Jerry G · Delhi, LABuilt 1973 · S/N 18261726 N8DMNelson Adwc LLC · Seminole, TXBuilt 1973 · S/N 18262225 N8GGFisher Financial Services Inc · Brookline, MABuilt 1973 · S/N 18262121 N9005MBuford David C · Bonaparte, IABuilt 1976 · S/N 18264639 N9006MHolliday Dean Trustee Et Al · Klamath Falls, ORBuilt 1976 · S/N 18264640 N9010MCrotts Aircraft Service Inc · Dodge City, KSBuilt 1976 · S/N 18264641 N9011Kro Bros LLC · Lebanon, OHBuilt 1973 · S/N 18261966 N9016MKinslow Aviation LLC · Prague, OKBuilt 1976 · S/N 18264644 N9018MMclain Daniel E · Baden, PABuilt 1976 · S/N 18264646 N9022MDaytona Beach Aero Club Inc · Ormond Beach, FLBuilt 1976 · S/N 18264647 N9033MBasinger Robert C · Freedom, PABuilt 1976 · S/N 18264652 N9045MCunningham Bill · Tulsa, OKBuilt 1976 · S/N 18264655 N9057MUnderhill James F · Charleston, WVBuilt 1976 · S/N 18264658 N9060MAshland Jeffrey C · Spirit Lake, IABuilt 1976 · S/N 18264659 N9065MWillecke Donald K · Punta Gorda, FLBuilt 1976 · S/N 18264662 N9066MHarbison Laura L · Redlands, CABuilt 1976 · S/N 18264663 N9070MBeyer Family Aviation LLC · Hamilton, MTBuilt 1976 · S/N 18264664 N9072M3580 Shelby Flyers LLC · Shelby, NCBuilt 1976 · S/N 18264665 N9075MBumback William R · Seattle, WABuilt 1976 · S/N 18264668 N9085MLee Aviation Group LLC · Fort Myers, FLBuilt 1976 · S/N 18264670 N9091MFrisbee Dennis R · Denton, TXBuilt 1976 · S/N 18264672 N91012Flyboys LLC · Jenks, OKBuilt 1973 · S/N 18261945 N9102MN3611q LLC · Chandler, AZS/N 18264676 N91035Ryan Mike · Glendale, AZBuilt 1973 · S/N 18261946 N9104MRufe Preston · Geneseo, NYBuilt 1976 · S/N 18264677 N91055Murray Joshua S · Camas, WABuilt 1973 · S/N 18261949 N91078T Or M LLC · Brentwood, TNBuilt 1973 · S/N 18261952 N9107MBurns Robert L · Bremen, GABuilt 1976 · S/N 18264679 N9108MHorinek Dave L · Goodland, KSBuilt 1976 · S/N 18264680 N91121Central Illinois Aviators Inc · Galesburg, ILBuilt 1973 · S/N 18261954 N9112MJlck LLC · Jordan, NYBuilt 1976 · S/N 18264682 N9113MGospel Ministries International Inc · Collegedale, TNBuilt 1976 · S/N 18264683 N91156Scarlett Ryan Jay · Sparks, NVBuilt 1973 · S/N 18261959 N91162Kelley Patrick J · Catawba, NCBuilt 1973 · S/N 18261960 N9117MPettigarrett LLC · Manchester, GABuilt 1976 · S/N 18264685 N91199Olmstead Daniel H · Kimberly, IDBuilt 1973 · S/N 18261967 N91231N91231 LLC · Columbia, MOBuilt 1973 · S/N 18261976 N91236Skylane 73 LLC · Altadena, CABuilt 1973 · S/N 18261980 N9128MBailliere Lawrence · Tucson, AZBuilt 1976 · S/N 18264690 N91310Foschi Davide · Ponte Vedra Beach, FLBuilt 1973 · S/N 18261988 N9132MA & J Leasing LLC · Lovington, NMBuilt 1976 · S/N 18264692 N9133MJones Ezra B III · Atlanta, GABuilt 1976 · S/N 18264693 N9135MHall John Douglas · Zachary, LABuilt 1976 · S/N 18264695 N913769-Six Inc · Zortman, MTBuilt 1973 · S/N 18261990 N91377Webster Marc · Glendale, CABuilt 1973 · S/N 18261991 N9137MRiverside Pilots Inc · Riverside, CABuilt 1976 · S/N 18264697 N91406Wimmer Luke R · Rogers, TXS/N 18261997

Back to Cessna 182P