OpenAirDocs.org
Broken Arrow, OK

Registered aircraft · 123

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 = 'BROKEN ARROW'
  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.

N1071LLake LA-4-200 · S/N 664Built 1975 · Grand Seaplanes LLCN120CMCessna 120 · S/N 11903Built 1946 · Laminar Skies Aviation LLCN1255SCessna TR182 · S/N R18201279Built 1979 · Smith David JN1270RBellanca 14-19-3 · S/N 4327Built 1966 · Dunbar Stephen E TrusteeN14ECEric S Clifford MM1 · S/N M-1-2171Built 2005 · Paulsen Tyler SN151SMGrout Marvin L PIETENPOL · S/N 302462774Built 1999 · 6ed Aircraft LLCN15962Piper PA-28-140 · S/N 28-7325213Romero Jason NathanialN1637FCessna 172H · S/N 17255032Laminar Skies Aviation LLCN175USCirrus Design SR22 · S/N 0570Atlas Property Management LLCN18155Cessna 150L · S/N 15073828Built 1972 · Willis Nathan EricN184NSchempp-Hirth STANDARD CIRRUS · S/N 9Built 1969 · Harper Robert JN18501Cessna 150L · S/N 15073894Dunbar Stephen E TrusteeN187Cessna T337G · S/N P3370208Built 1975 · Molina Luis JN193FFlight Design General Avn F2-LSA · S/N T-20-12-02Built 2021 · Warren WalterN1947RHead Balloons AX8-88B · S/N 293Short Dennis LN194STLandrum Tracy L RV-9A · S/N 90656Built 2009 · Rv9 Holdings LLCN19587Cessna 150L · S/N 15074509Built 1973 · Steward Matthew C AN2129FCessna U206 · S/N U206-0329Built 1965 · Stewart Madison F Co Persona RepresentativeN21ZUChapman Patrick L SLING TSI · S/N 242SKChapman Patrick LN22027Cessna 150H · S/N 15068018Built 1967 · Lyles Bobbi LN2219MRaytheon A36 · S/N E3149Built 1998 · Dubya Aviation LLCN235SEBeech A36 · S/N E-1953Built 1981 · Plane Flt LLCN24PUHerbison R/Petryk R/Mckay D PITTS S-1D · S/N 7-0483Sale reportedBuilt 1986N252DECR Dreams Charters SW-51 · S/N 0019Cr Dreams Charters CorpN2580YBalloon Works FIREFLY 7-15 · S/N F7-878Built 1995 · Short Dennis LN25DSSeymour PAZMANY PL-2 · S/N 25Built 1971 · Cavazos Jacobo ON26718Gulfstream American AA-5A · S/N AA5A0673Owen James TN270SVCessna 152 · S/N 15282329Built 1978 · Jones Joseph DN272MSBeech S35 · S/N D-7429Built 1964 · Hinkle PaulN2742RPiper PA-28R-200 · S/N 28R-35281Built 1969 · Collinsworth Frederick WN2772RRay Earl D FLIGHTSTAR IISC · S/N 301First renewal noticeBuilt 2001 · Butler Marshall BN295BBBaird D/Beedon D RANS COYTE S-6ES · S/N 019255Built 1994 · Hamilton Garl Wendell JrN2962XCessna 177 · S/N 17700362Built 1967 · Romine John MN300BGBurkhart Grob G-109B · S/N 6390Harper Robert JN3022YPiper PA-28-236 · S/N 28-7911149Built 1979 · W&M Piper Dakota LLCN307DSSterling Douglas Jon FLIGHTSTAR II · S/N 127First renewal noticeBuilt 2005 · Butler Marshal BN3171PNorth American AT-6C · S/N 88-12553Built 1943 · Stinnett Joel BN3293RPiper PA-28R-180 · S/N 28R-31264Built 1969 · Brook Jacob CN334CCPiper PA-28-235 · S/N 28-7610122Built 1976 · Haspell John CN352GBCessna 177RG · S/N 177RG1075Built 1976 · Davis David NN35LLSmith AEROSTAR 601P · S/N 61P-0388-130Physicians Systems IncN36013Bellanca 8KCAB · S/N 98-73Built 1973 · Jones Joseph DN37850Porterfield FP-65 · S/N 997Built 1941 · Baca Gary PaulN384EMCessna 650 · S/N 650-0144Built 1987 · Isi Aviation Support Services LLCN3866WPiper PA-32-260 · S/N 32-810Built 1966 · N3866w LLCN3871XAero Commander 100 · S/N 168Built 1967 · Johnson Roger LN3921RCessna 172H · S/N 17255421Built 1966 · 3921r Aviation LLCN392HUPowrachute AIRWOLF 912 · S/N A126ULSZongker Jeremy CN3946MPiper PA 46-350P · S/N 4636621Built 2014 · Plane Flt LLCN412LCFlight Design CTSW · S/N 05-09-12Built 2005 · Luck Floyd E
Back to Broken Arrow, OK