OpenAirDocs.org
Ada, OK

Registered aircraft · 43

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'OK' AND g.registrant_city = 'ADA'
  ORDER BY g.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.

N100RSXag P100 PRO · S/N 1863FPEG8219425897PERaintree Services LLCN11RTBeech V35 · S/N D-8420Built 1967 · Braly And Braly PcN1284YCessna 150B · S/N 15059684Built 1962 · Beamer Enterprises LLCN14873Howard DGA-8 · S/N 73Heartland Aviation LLCN201ZBMooney M20J · S/N 24-0415Built 1978 · Browne Michael TN202TPBell Helicopter Textron Canada 206L-4 · S/N 52364Built 2007 · Heartland Aviation LLCN20832Cessna 182P · S/N 18261240Built 1972 · Wallace FredN208MMHawker Beechcraft 390 · S/N RB-232Built 2008 · Heartland Aviation LLCN223TNCirrus Design SR22 · S/N 2698Built 2007 · General Aviation Modifications IncN241RSHawker Beechcraft G36 · S/N E-3879Built 2008 · Hood Jeffery MN257TLCirrus Design SR20 · S/N 2165Built 2012 · Tornado Alley Turbo IncN300KABeech B300 · S/N FL-28Built 1990 · Heartland Aviation LLCN302ZBeech 35-33 · S/N CD-201Built 1960 · Sutherland Derrick LN3133TCessna 177 · S/N 17700433Built 1967 · Giddy Up Aviation LLCN333DDNew Century Aerosport RADIAL ROCKET · S/N 115Heartland Aviation LLCN3363HErcoupe 415-C · S/N 3988Bailey Riley W JrN34SYBeech D-45 · S/N BG-246Built 1956 · General Aviation Modifications IncN35102Cessna 177B · S/N 17702208Built 1974 · Allen Russell W TrusteeN3592XMooney M-20G · S/N 680161Built 1968 · Bryant David WayneN35VTBeech 35 · S/N D-696General Aviation Modifications IncN36TNBeech B36TC · S/N EA-403Built 1984 · Tornado Alley Turbo IncN4137LPiper PA-28-181 · S/N 2843249Built 1999 · Luv 2 Fly Ada LLCN52686Beech D17S · S/N 4882Heartland Aviation LLCN59CTBeech A36 · S/N E-1719Built 1980 · Tornado Alley Turbo IncN600CNDassault FALCON 2000EX · S/N 710Built 2013 · Chickasaw NationN603CNDassault FALCON 2000EX · S/N 739Built 2016 · Chickasaw NationN621RJCirrus Design SR22 · S/N 0333Built 2002 · Wheels Up LLCN62WTBeech B-55 · S/N TC-1988Built 1976 · Heartland Aviation LLCN6728BDJI PHANTOM 3 ADVANCED · S/N P76DCH27016580Byng Public SchoolN715TCessna 152 · S/N 15279611Built 1977 · Lucy RoyN72TNCessna R172K · S/N R1722028Built 1976 · Tornado Alley Turbo IncN731ADStinson 108-3 · S/N 108-5137Built 1950 · Smith Frank JN73927Cessna 172N · S/N 17267751Built 1976 · Abcd Ventures LLCN7870LBeech 95-C55 · S/N TE-336Built 1967 · Cnf LLCN8092RBeech 36 · S/N E-161Boogers In Flight LLCN8355GCessna 150F · S/N 15062455Built 1965 · Grant Jimmy LN850CESocata TBM 700 · S/N 584Built 2012 · Ada Coca-Cola Bottling CoN8786EPiper PA-28-151 · S/N 28-7615162Built 1976 · Luv 2 Fly Ada LLCN888CDRaytheon G58 · S/N TH-2127Built 2005 · True Steel IncN912HBeech 95-C55 · S/N TE-143Built 1966 · Civil Aviation Group LLCN9345Hargraves W D/Quad City Ultra CHALLENGER II · S/N CH2-0304-2455Sliger Faye FN9416VMooney M20E · S/N 700050Cothren Edward WN98DPAviat A-1B · S/N 2309Built 2005 · Heartland Aviation LLC
Back to Ada, OK