Skip to content

Registered aircraft · 212

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

N70350Bigwings Ag Inc · Delavan, MNS/N 18801895T N70387Becker Flying Service Inc · Hartington, NEBuilt 1974 · S/N 18801905 N70403Mccormick Eugene C DBA · Tyler, ALBuilt 1974 · S/N 18801912T N72091Peralta Jose Ramon · Sinking Spring, PAFirst renewal noticeBuilt 1974 · S/N 18801943T N72947Greer Glenn M · Eugene, ORBuilt 1972 · S/N 18800947 N731ABA & C Ag Aviation Inc · Unadilla, GABuilt 1976 · S/N 18802735T N731BGKutschera Theodore C DBA · Callicoon, NYBuilt 1976 · S/N 18802763T N731BMBenaiah Holdings Corp · Marion, KYS/N 18802768T N731CENoe Aviation LLC · Vinton, IABuilt 1976 · S/N 18802785T N731CQD & K Aviation Inc · Milford, IABuilt 1977 · S/N 18802794T N731ECFitchett Bradley S DBA · Ellsworth, KSS/N 18802830 N731EQUnited States Department Of Agriculture · Edinburg, TXBuilt 1976 · S/N 18802843T N731ESSky Tech Inc · Dorchester, NES/N 18802845T N731FMNew Frontier Aviation LLC · Fort Benton, MTBuilt 1977 · S/N 18802862T N731FPLihs Ryan J · Sioux City, IABuilt 1977 · S/N 18802864T N731GDRegistration Pending · Walnut, ILRegistration pendingBuilt 1977 · S/N 18802877T N731GPUpshaw John L Jr · Claude, TXBuilt 1977 · S/N 18802887T N731GTDigger Dougs Crop Dusting Services Inc · Hollandale, WIBuilt 1977 · S/N 18802891T N731KWVann Dudley C DBA · Greenville, NCBuilt 1977 · S/N 18802963T N731LACmk Aerial Inc · Sutton, NEBuilt 1977 · S/N 18802967T N731LFMcneill Dudley T · Happy, TXS/N 18802972 N731MKMccormick Eugene C DBA · Tyler, ALS/N 18802999T N731MRMerced County Mosquito Abatement District · Merced, CAS/N 18803005T N731PHTorkelson Charles A · San Antonio, TXBuilt 1977 · S/N 18803044T N731PMAir Ag Inc · Tarboro, NCBuilt 1977 · S/N 18803048 N731QCTim Whitfield Aviation · Fairfield, NCBuilt 1977 · S/N 18803063T N731TBEastern Flying Service Inc · Middletown, DEBuilt 1978 · S/N 18803133 N731TQSnider Scott E DBA · Turner, MTS/N 18803146T N731TSSantana Hector Rafael · Crystal River, FLBuilt 1978 · S/N 18803148T N731UFPeniston Bob · Chillicothe, MOBuilt 1978 · S/N 18803160T N731VXGoff Bayou LLC · Shelby, MSBuilt 1978 · S/N 18803200T N731VYCarr Scott A · Allen, NEBuilt 1978 · S/N 18803201T N731WVKutschera Theodore C DBA · Callicoon, NYBuilt 1978 · S/N 18803222T N731XGPeniston Charles R · Chillicothe, MOBuilt 1978 · S/N 18803233T N731XNPeniston Bob · Chillicothe, MOBuilt 1978 · S/N 18803239T N731YRAbernathy Larry D · Tipton, OKBuilt 1978 · S/N 18803266 N76AGSkyview Applicators LLC · Hartington, NEBuilt 1976 · S/N 18802699T N78417Mcelwain Russell D · Lancaster, KSBuilt 1974 · S/N 18801952T N788BTPowers Elbie L · Roseboro, NCFirst renewal noticeBuilt 1976 · S/N 18802583 N79080Snider Roger A · Harlem, MTBuilt 1974 · S/N 18801962 N79260Sale Reported · Xxx, OKSale reported, pending cancellationBuilt 1974 · S/N 18801968T N8075GVaughns Flying Service Inc · Reese, MIBuilt 1973 · S/N 18801226T N8079GBoney Grady · Rhine, GABuilt 1973 · S/N 18801227T N8094GTri Rotor Spray & Chemical · Ulysses, KSBuilt 1973 · S/N 18801230 N8130GBank Of Utah Trustee · Salt Lake City, UTBuilt 1973 · S/N 18801243T N8262GRegistration Pending · Hampshire, ILRegistration pendingBuilt 1973 · S/N 18801274 N8277GCountry Aero LLC · Darwin, MNBuilt 1973 · S/N 18801281T N8288GFord Flying Service Inc · Doerun, GABuilt 1973 · S/N 18801287 N8296GKiehl Austin J · Winnett, MTBuilt 1973 · S/N 18801293 N84497N84497 LLC · Omaha, NEBuilt 1974 · S/N 18801989T

Back to Cessna A188B