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.

N4898QTaylor Aviation Inc · Fort Benton, MTBuilt 1976 · S/N 18802634T N4902RBecker Flying Service Inc · Hartington, NEBuilt 1975 · S/N 18802420T N4904QFoxtrot Air LLC · Highmore, SDBuilt 1976 · S/N 18802639T N4905RFlight Level Zero LLC · Othello, WABuilt 1975 · S/N 18802423T N4907RMills Spraying Service Inc · Pahokee, FLBuilt 1975 · S/N 18802425T N4908Q1lowflyer Inc · Harrisonville, MOBuilt 1976 · S/N 18802643T N4914QGudgel Daniel R · Lemoore, CABuilt 1976 · S/N 18802649 N4921RBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 18802438T N4927QWakefield Aircraft LLC · Cooperstown, NDBuilt 1976 · S/N 18802662T N4930RSouther Field Aviation Inc · Americus, GABuilt 1975 · S/N 18802447T N4931RRegistration Pending · Westhope, NDRegistration pendingBuilt 1975 · S/N 18802448T N4933QDarter Lloyd R · Mountain Grove, MOBuilt 1976 · S/N 18802668T N4937RAllred Bobby A · Centre, ALBuilt 1975 · S/N 18802454T N4939RMiller Farms Jv · Opheim, MTBuilt 1975 · S/N 18802456T N4944RRoma Air Corp · Belle Glade, FLBuilt 1975 · S/N 18802461T N4947QDavison Aviation LLC · Garnett, KSBuilt 1976 · S/N 18802682T N4948RBlain Monte W · Joliet, MTBuilt 1975 · S/N 18802465 N4949RValley Flying Service Inc · Orleans, NEBuilt 1975 · S/N 18802466T N4958QSnider Scott E DBA · Turner, MTBuilt 1976 · S/N 18802692T N4970QPettis Ag Aviation LLC · Atlantic, IABuilt 1976 · S/N 18802704T N4991REast Side Mosquito Abatement District · Modesto, CABuilt 1975 · S/N 18802479T N4994RCountry Air Service Inc · Hecla, SDS/N 18802481T N4KLRanspot Richard · Burlington, TXBuilt 1973 · S/N 18801394 N53105Pence Dale E · Garnett, KSBuilt 1974 · S/N 18801625T N53183Allred Gina D Administrator · Centre, ALBuilt 1974 · S/N 18801668T N53211Anderson Aerial Spraying Service Inc · Canby, MNS/N 18801688T N53227Birddog Aviation LLC · Stockton, KSBuilt 1974 · S/N 18801699T N53243Fly Low Aviation LLC · Ashley, NDBuilt 1974 · S/N 18801706T N53245Kirk Ben C · Louisville, MSBuilt 1974 · S/N 18801708T N53277Petecraft Aviation Services Inc · Plains, GABuilt 1974 · S/N 18801732T N53315Denton Aerial Spraying · Las Animas, COBuilt 1975 · S/N 18802213T N53319Souther Field Aviation Inc · Americus, GAFirst renewal noticeS/N 18801758T N53368Arnt Aerial Spraying Inc · Worthington, MNBuilt 1974 · S/N 18801790 N53391Schwend Brian · Forsyth, MTBuilt 1974 · S/N 18801805T N5708GAir Dakota Flite · Hettinger, NDBuilt 1973 · S/N 18801138 N5987GSchwend Brian · Forsyth, MTBuilt 1973 · S/N 18801166 N6032RMatecumbe Flying Service Inc · Immokalee, FLBuilt 1976 · S/N 18802734T N6048GWitthuhn Johnie B · Callaway, NEBuilt 1973 · S/N 18801172T N6133GRosebud Aviation · Gregory, SDBuilt 1973 · S/N 18801176 N6509GMehling Robert C · Hardin, MTS/N 18801202 N6606QAirtrust LLC - 1 - Series 1 Trustee · Sheridan, WYBuilt 1977 · S/N 18802951T N6607BWhalen Mark P · Millington, MDBuilt 1977 · S/N 18802984T N6623GMehling Robert C · Hardin, MTS/N 18801208 N6656GCommonwealth Of Massachusetts · Plymouth, MABuilt 1973 · S/N 18801210 N666JBCopenhaver Tracy K · Anthony, KSBuilt 1973 · S/N 18801427 N70063Welch Thomas R DBA · Modesto, CABuilt 1974 · S/N 18801827T N70141Priewe Flying Service LLC · Como, MSBuilt 1974 · S/N 18801847T N70231Low Level Aero LLC · Myakka City, FLBuilt 1974 · S/N 18801873T N70288Dakota Aircare Inc · Wagner, SDBuilt 1974 · S/N 18801879T N70326Triple E Farms LLC · Peculiar, MOBuilt 1974 · S/N 18801887T

Back to Cessna A188B