Skip to content

Registered aircraft · 486

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

N76RJMother Earth Flight Inc · Wilmington, DES/N 18268494 N777HRLansing Skylane Inc · Orland Park, ILBuilt 1981 · S/N 18267963 N779SPPreferco LLC · Fargo, NDBuilt 1986 · S/N 18268576 N788MKRabin Michael D · Charlottesville, VAS/N 18268233 N799HPBristol Bay Air Service Inc · Dillingham, AKS/N 18268575 N79NHSchmidt Aviation Inc · Boring, ORBuilt 1982 · S/N 18268168 N800PReisch Travis S · Miami, OKBuilt 1983 · S/N 18268305 N8047ECivil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 18268385 N805SLCounty Of San Luis Obispo Sheriffs Office · San Luis Obispo, CABuilt 1982 · S/N 18268271 N80WCAir-Quip LLC · Boulder City, NVBuilt 1981 · S/N 18267838 N8115EGrillos Emmanuel John II · Kent, WABuilt 1984 · S/N 18268386 N81MPPatriot Aviation Inc · Greenville, DEBuilt 1985 · S/N 18268520 N823BEStanley Joseph A Trustee · Thornville, OHBuilt 1982 · S/N 18268162 N8280ETrivedi Jay S · Skokie, ILBuilt 1984 · S/N 18268389 N82BAMcilnay Brian S · Athens, TNBuilt 1981 · S/N 18268084 N82PAHart Michael Anthony · Rockford, ILFirst renewal noticeBuilt 1986 · S/N 18268586 N830BABarr Air Patrol LLC · Mesquite, TXBuilt 1984 · S/N 18268390 N8323EBrod Norman B Trustee · Napa, CABuilt 1984 · S/N 18268391 N83JVClark Jason · Gig Harbor, WABuilt 1983 · S/N 18268329 N851CAT&B Aero LLC · Jacksonville, FLS/N 18267851 N853HLJohnson Jeffrey A · Fort Collins, COBuilt 1985 · S/N 18268446 N859BABarr Air Patrol LLC · Mesquite, TXS/N 18268080 N900MPSweet Fred A · Loves Park, ILBuilt 1981 · S/N 18268093 N908HPNiessner Steven A · Golden, COBuilt 1981 · S/N 18267881 N9130HStockhausen Andrew J Jr · New Berlin, WIBuilt 1981 · S/N 18267925 N9186HWicked Wings Aviation LLC · Dover, DEBuilt 1981 · S/N 18267926 N91LPDreisewerd William · Winfield, MOBuilt 1984 · S/N 18268423 N9209HUnited States Air Force Owner · Elmendorf Afb, AKBuilt 1981 · S/N 18267927 N9303XHawaiian Airlift Company Llp · Kihei, HIS/N 18268479 N9307HMoss Jon · Gridley, CABuilt 1981 · S/N 182-67929 N9313XSjb Farms LLC · Albany, ORS/N 18268484 N9314XFortney Rick · Mc Alpin, FLBuilt 1985 · S/N 18268485 N9315XBowen Floyd Eugene Jr Trustee · Bend, ORBuilt 1985 · S/N 18268486 N9316XZilberberg Tamir · North Hollywood, CABuilt 1985 · S/N 18268487 N9317EBrothers Brian · Columbus, OHBuilt 1984 · S/N 18268394 N9320XBlue Skies Air LLC · Portland, ORBuilt 1985 · S/N 18268488 N9321XSakonnet Aircharter · Bradenton, FLBuilt 1985 · S/N 18268489 N9322XCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 18268490 N9327ERhoades Christine · Laguna Beach, CABuilt 1984 · S/N 18268396 N932FWJones Joseph A · Covington, WABuilt 1985 · S/N 18268492 N9332HLeppke Lyle K · Marion, KSBuilt 1981 · S/N 18267935 N9335EParanjpe Vasant · Pittstown, NJBuilt 1984 · S/N 18268397 N9335XFlorida Gas Transmission Co · Spring, TXBuilt 1985 · S/N 18268495 N9338EComanche Hills Aircraft LLC · Lampasas, TXBuilt 1984 · S/N 18268398 N9338XHathaway David P · Waterbury, VTBuilt 1985 · S/N 18268496 N9341XKent Steven P · Warwick, NYBuilt 1985 · S/N 18268497 N9351XSasser Konnie B · Granbury, TXBuilt 1985 · S/N 18268499 N9353ECivil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 18268402 N9355XTaylor John A · Lexington, MABuilt 1985 · S/N 18268501 N9359XNorthstar Management Inc · Clovis, CABuilt 1985 · S/N 18268503

Back to Cessna 182R