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.

N86407Donalds Flying Service Inc · Pantego, NCBuilt 1975 · S/N 18802013T N86440Wilde Air Service-Huron LLC · Volga, SDBuilt 1975 · S/N 18802014T N888BTSpraymax Corp · Miami, FLBuilt 1974 · S/N 18801782T N8999GSouther Field Aviation Inc · Americus, GAFirst renewal noticeBuilt 1973 · S/N 18801344 N9068RHrabe Dusten · Chamberlain, SDBuilt 1975 · S/N 18802095T N9083HNewton Aero LLC · Hurdland, MOBuilt 1974 · S/N 18801829T N9083RStuder Alfred C · Shelby, MIBuilt 1975 · S/N 18802104T N9094RPetecraft Aviation Services Inc · Plains, GABuilt 1975 · S/N 18802110T N91084Cropair Flying Service Inc · Cody, WYBuilt 1975 · S/N 18802020T N91152Dt Pralle Enterprise Inc · Hampton, IABuilt 1975 · S/N 18802022T N9138GTlc Flying Inc · Colfax, WABuilt 1973 · S/N 18801390 N9157RHolmes Ronald W · Kent, ORBuilt 1975 · S/N 18802135T N9166RSchwend Brian · Forsyth, MTS/N 18802136T N9171GKiehl Flying Service LLC · Winnett, MTBuilt 1973 · S/N 18801407T N9172GRegistration Pending · Turner, MTRegistration pendingBuilt 1973 · S/N 18801408T N91919Anderson Aerial Spraying Service Inc · Canby, MNS/N 18802053T N9204GSchwend Brian · Forsyth, MTBuilt 1973 · S/N 18801423 N9205RRegistration Pending · Manito, ILRegistration pendingBuilt 1975 · S/N 18802150T N9230RMeyer Bros Ag LLC · Algona, IABuilt 1975 · S/N 18802171T N9234RRegistration Pending · Maurice, IARegistration pendingBuilt 1975 · S/N 18802173T N9240RAir Dakota Flite · Hettinger, NDBuilt 1975 · S/N 18802178T N9242RAir Dakota Flite Inc · Hettinger, NDBuilt 1975 · S/N 18802180T N9243RC & L Holzwarth Inc · Virden, ILBuilt 1975 · S/N 18802181T N9249RGreat Plains Applications LLC · Slayton, MNBuilt 1975 · S/N 18802187T N9252RBank Of Utah Trustee · Salt Lake City, UTBuilt 1975 · S/N 18802189T N92593Snider Scott E DBA · Turner, MTBuilt 1975 · S/N 18802067T N9261GAllred Bobby A · Centre, ALBuilt 1973 · S/N 18801441 N9264RAir Dakota Flite Inc · Hettinger, NDBuilt 1975 · S/N 18802196T N92701Kyllo Jeffrey K · Larimore, NDBuilt 1975 · S/N 18802070T N9272RFarrow Sammie N Jr · Cordele, GABuilt 1975 · S/N 18802200T N9283RAllied Sprayers Inc · Hawley, TXBuilt 1975 · S/N 18802211 N9286RWiebe Aerial Applications LLC · Peabody, KSBuilt 1975 · S/N 18802212 N9313GSchwend Brian · Forsyth, MTBuilt 1973 · S/N 18801450 N9355RSkyline Aviation LLC · Lewistown, MTBuilt 1975 · S/N 18802254T N9380RFarm Air Inc · Astoria, ILBuilt 1975 · S/N 18802268 N9385GDakota Aircare Inc · Wagner, SDBuilt 1974 · S/N 18801468T N9482RWindy Lane Farms Transport LLC · Mulberry, INBuilt 1975 · S/N 18802292T N9485RStevenson Flying Service LLC · Selden, KSBuilt 1975 · S/N 18802294T N9486RAnderson Aerial Spraying Serv Inc · Canby, MNBuilt 1975 · S/N 18802295T N9498GSak III LLC · Miller, SDS/N 18801503T N9500GEphbaugm Equipment LLC · Hartline, WABuilt 1974 · S/N 18801504T N9509GMid Continent Aircraft Corp · Hayti, MOBuilt 1974 · S/N 18801508T N9510JOrange County Mosquito Control District · Orange, TXBuilt 1981 · S/N 18803814 N9540GSchwend Brian · Forsyth, MTBuilt 1974 · S/N 18801520 N9541GAllen Charles Mark · Puryear, TNBuilt 1974 · S/N 18801521 N9548GMeyer Bros Ag LLC · Algona, IABuilt 1974 · S/N 18801526T N9552GJesse Shipman Farms LLC · Honey Grove, TXBuilt 1974 · S/N 18801529T N9555GMccormick Eugene C · Tyler, ALBuilt 1974 · S/N 18801531 N9556JS & D Spraying Service Inc · Panhandle, TXBuilt 1981 · S/N 18803821 N9561GFlying D Aero LLC · Colorado City, TXBuilt 1974 · S/N 18801536T

Back to Cessna A188B