Skip to content

Registered aircraft · 1,565

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

N5127NSierra Breeze LLC · Springfield, MOS/N 18267534 N5131NPiedmont Aircraft LLC · North Myrtle Beach, SCBuilt 1980 · S/N 18267538 N5136N5136n LLC · Las Vegas, NVBuilt 1980 · S/N 18267540 N513SCInstant Whip Foods Inc · Columbus, OHBuilt 1978 · S/N 18266293 N5144NL-3 Communications Eo/Ir Inc · Loveland, COBuilt 1979 · S/N 18267543 N514TDDay William B · Conroe, TXBuilt 1979 · S/N 18267361 N5157NAms Aviation LLC · South Bend, INBuilt 1980 · S/N 18267549 N5159NO Bleness Kevin W · Bethel, AKBuilt 1980 · S/N 18267550 N5161NLewis Justin R · Frederick, OKBuilt 1980 · S/N 18267552 N5164NCaribbean Way Of Life Inc Trustee · Wilmington, DEBuilt 1980 · S/N 18267554 N5168NRidgley Kirk L · Shingle Springs, CABuilt 1980 · S/N 18267555 N516CACharlie Alpha Flying Club · Sunnyvale, CABuilt 1978 · S/N 18266702 N5170NVx LLC · Melbourne, FLBuilt 1980 · S/N 18267557 N5175NArkansas Bolt Co · Little Rock, ARBuilt 1980 · S/N 18267560 N5177NMacelvaine William Stephen · Morro Bay, CABuilt 1980 · S/N 18267561 N517DBBerry Bruce E · Louisville, TNBuilt 1977 · S/N 18266021 N5181NValiair Lc Trustee · Casper, WYBuilt 1980 · S/N 18267562 N51SPDepartment Of Public Safety · Dover, DEBuilt 1980 · S/N 18267563 N51YTRupp Steven S · Cameron Park, CABuilt 1978 · S/N 18266686 N5202NNorthern Aviation LLC · Palmer, AKBuilt 1980 · S/N 18267568 N5203NNoam Eli · New York, NYBuilt 1980 · S/N 18267569 N5209NRiver City Aero Club Inc · Columbus, GABuilt 1980 · S/N 18267572 N5212NR C Sherwood Grain Co · Los Banos, CABuilt 1980 · S/N 18267574 N5215NFedrigo John A · Moneta, VABuilt 1980 · S/N 18267577 N5218NMorin Shawn D · Franklin, TNBuilt 1980 · S/N 18267579 N5219NA Cloud Above Aviation LLC · Spooner, WIBuilt 1980 · S/N 18267580 N521BSAtlas Aviation LLC · Marietta, GAS/N 18266263 N5224NCasper James R · Decorah, IABuilt 1980 · S/N 18267581 N5225NBartlett Joseph L · Eugene, ORBuilt 1980 · S/N 18267582 N5226NGriffin Franklin Todd · Grand Junction, COBuilt 1980 · S/N 18267583 N5228NMiller Kenneth M · Capistrano Beach, CABuilt 1980 · S/N 18267584 N5230NHostetler Todd · Wausau, WIBuilt 1980 · S/N 18267586 N5231NBrothers Implement Co Inc · Hillsboro, TNBuilt 1980 · S/N 18267587 N5232NFlorida Gas Transmission Co · Spring, TXBuilt 1980 · S/N 18267588 N523DTKuwinda Air LLC · Midland, TXBuilt 1979 · S/N 18267130 N523GGAviacion Del Oeste Inc · Mayaguez, PRBuilt 1980 · S/N 18267537 N5244NCongressional Flying Club Inc · Gaithersburg, MDBuilt 1980 · S/N 18267594 N5249NRed Lodge Flying Club Inc · Red Lodge, MTBuilt 1980 · S/N 18267598 N5250NCaturia James J · Hastings, MNBuilt 1980 · S/N 18267599 N5251NCenterline Aviation Services LLC · Huntersville, NCBuilt 1980 · S/N 18267600 N5252NKensy Ronald S · Panama City, FLBuilt 1980 · S/N 18267601 N5253NBlair Jonathon M · Sandpoint, IDBuilt 1980 · S/N 18267602 N5255NLucas David · Lodi, OHBuilt 1980 · S/N 18267604 N5256NGospel Ministries International · Collegedale, TNBuilt 1980 · S/N 18267605 N5257NAmanda Air Inc · Talladega, ALBuilt 1980 · S/N 18267606 N5258NOffcourt Ltd · Del Mar, CABuilt 1980 · S/N 18267607 N525LRSkywalker Leasing LLC · Wilmington, DEBuilt 1980 · S/N 18267356 N5260NBates Management Inc · Woodstock, GAS/N 18267609 N5261NCrowe Bradley Allen · North Chelmsford, MABuilt 1980 · S/N 18267610 N526VBGilbert Benjamin N Trustee · Chico, CABuilt 1977 · S/N 18265954

Back to Cessna 182Q