Skip to content

Registered aircraft · 653

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

N5278VZubrod John W · Ebony, VABuilt 1977 · S/N R1722285 N527CAIsaacson Scott D · San Diego, CABuilt 1977 · S/N R172-2510 N5280T368 Air 2 LLC · Higley, AZS/N R1722850 N531CAJja Transportation LLC · Springville, UTBuilt 1977 · S/N R1722675 N5324VAviation Resources LLC · Post Falls, IDBuilt 1977 · S/N R1722288 N5351VHarris Adam K · Shrewsbury, MABuilt 1977 · S/N R1722292 N53PLPocquette Beau W · Deer River, MNBuilt 1976 · S/N R1722171 N5405VVidal Aviation LLC · Gaithersburg, MDBuilt 1977 · S/N R1722294 N5418VPotters Earl C · Poreby Ok MragowoBuilt 1977 · S/N R1722296 N5453VTim Whitfield Aviation Inc · Farfield, NCBuilt 1977 · S/N R1722299 N55CKDobson Billy M · Tichnor, ARS/N R1722409 N560SPProtea Group Management Services LLC · Carrollton, TXS/N R1722359 N575RWWashington County · Hillsboro, ORBuilt 1978 · S/N R1722881 N59JFJpf Holdings LLC · Wilmington, DEBuilt 1977 · S/N R1722325 N59XPCobb John M · Fayetteville, TNBuilt 1977 · S/N R1722015 N600XPPintail Aero LLC · Shreveport, LABuilt 1976 · S/N R1722083 N6036KValley Flyers Inc · Lebanon, NHBuilt 1976 · S/N R1722021 N606LPLee Andy · Riverside, CABuilt 1976 · S/N R1722020 N6075KWilliams Todd D · Perry, UTBuilt 1976 · S/N R1722025 N611GGPence Edward R · Bakersfield, CABuilt 1979 · S/N R1723110 N612RTimm Robert S · Minneapolis, MNBuilt 1977 · S/N R1722687 N6149KTurbine Financial Group LLC · Ogden, UTBuilt 1976 · S/N R1722029 N6150KAult Greg · Princeton, INBuilt 1976 · S/N R1722030 N6192KSmith Chris Sean · Pendleton, SCBuilt 1976 · S/N R1722034 N6243KAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1976 · S/N R1722036 N629LBBachman Aviation LLC · Independence, IABuilt 1979 · S/N R1723063 N6304KMeadows Michael M · Cypress, TXBuilt 1976 · S/N R1722038 N6363KKnoblock Stephen A · Acworth, GABuilt 1976 · S/N R1722041 N6382KN6382k LLC · Palm City, FLS/N R1722042 N6417KVaro-Real Investments Inc · Visalia, CAS/N R1722044 N6452KHart Jeffrey D · Eagan, MNBuilt 1976 · S/N R1722045 N65EBKansas Farm & Ranch In · Seneca, KSBuilt 1977 · S/N R1722331 N65WPWarnken James V · Pleasanton, TXBuilt 1977 · S/N R1722232 N66003Nesheim William A · Holderness, NHBuilt 1979 · S/N R1723000 N66MEDm Asset Management LLC · Plain City, OHBuilt 1977 · S/N R1722298 N696ALPas Aviation Inc · Modesto, CAS/N R1722047 N69EMSmith Michael A · Willows, CAS/N R1723374 N69FZDeweese Michel J · Rockvale, TNS/N R1722546 N6CEQuinn Paul R · Southlake, TXBuilt 1978 · S/N R1722874 N70WMKeatts Herbert G · Dover, TNFirst renewal noticeBuilt 1980 · S/N R1723361 N710TRSln Aviation LLC · Salina, KSBuilt 1977 · S/N R1722768 N711XPArsenie Michael D · Roxbury, CTBuilt 1976 · S/N R1722119 N7151KKyllo Jeff K · Larimore, NDBuilt 1976 · S/N R1722048 N717RAWahl Charles S · Cameron Park, CABuilt 1977 · S/N R1722740 N7186CRegistered aircraftBuilt 1973 · S/N 680 N7226V226v LLC · Zachary, LABuilt 1977 · S/N R1722302 N724KRClean Patterns LLC · Mesa, AZBuilt 1976 · S/N R1722050 N72TNTornado Alley Turbo Inc · Ada, OKBuilt 1976 · S/N R1722028 N72XPFlink Frank B Jr · Shawnee Mission, KSFirst renewal noticeBuilt 1977 · S/N R1722396 N7311VWiliams Daniel L · Liverpool, NYBuilt 1977 · S/N R1722303

Back to Cessna R172K