OpenAirDocs.org
Hawthorne, CA

Registered aircraft · 34

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 = 'CA' AND g.registrant_city = 'HAWTHORNE'
  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.

N1313XBellanca 14-19-3 · S/N 4223M & S Airsupply DBAN154TSBoeing 737-800 · S/N 30515Built 2002 · Falcon Aviation Holdings LLCN1823CCessna 182S · S/N 18280171Built 1998 · A&E Flying Club Of Los AngelesN1998RCessna 172R · S/N 17280389Built 1998 · A & E Flying Club Of Los Angeles IncN21643Cessna 172M · S/N 17263982Built 1974 · A&E Flying Club Of Los AngelesN23676Cessna 182S · S/N 18280324Built 1998 · A&E Flying Club Of Los Angeles IncN272BGGulfstream Aerospace GV-SP (G550) · S/N 5164Built 2007 · Falcon Landing LLCN317TBeech 35-33 · S/N CD-95Built 1960 · Mascelli John SN328GTDornier 328-300 · S/N 3183Built 2001 · Advanced Air LLCN330ENBoeing Of Canada/Dehav Div DHC-8-311 · S/N 274Built 1991 · Universal Hydrogen CoN334MSFairchild Dornier DORNIER 328-300 · S/N 3214Built 2002 · Advanced Air LLCN350ESHawker Beechcraft B300 · S/N FL-703Built 2010 · Advanced Air LLCN3770JCessna 150G · S/N 15065070Built 1966 · Azad Raja MN395AABeech B300 · S/N FL39Built 1991 · Advanced Air LLCN395AVRaytheon B300 · S/N FL-375Advanced Air LLCN395MBRaytheon B300 · S/N FL-347Built 2002 · Advanced Air LLCN395MSDornier Luftfahrt DORNIER 328-300 · S/N 3213Built 2002 · Advanced Air LLCN53512Cirrus Design SR22 · S/N 0868Built 2004 · Rapp Steven BN535EMCessna T206H · S/N T20608989Built 2010 · City Of HawthorneN575RDRaytheon B300 · S/N FL-288Built 2000 · Steelwood Partners LLCN613WCCessna 337A · S/N 337-0372Built 1966 · Ampaire IncN628TSGulfstream Aerospace GVI (G650ER) · S/N 6177Built 2015 · Falcon Landing LLCN65710Cessna 172P · S/N 17275828Built 1982 · Beach Cities Aviation Academy LLCN68342Cessna 152 · S/N 15282269Built 1978 · M & S Air Supply Inc DBAN714MGCessna 150M · S/N 15079277Built 1977 · Manandhar Raj PN79198Cessna 172K · S/N 17257952Azad Raja MN79HCBeech A36 · S/N E-2538Built 1990 · Bmc GroupN83FDDougherty Joseph Leo GLAS STAR · S/N 5059Built 1998 · Bury Christopher EN8812HNorth American NAVION A · S/N NAV-4-812Built 1947 · Bruck Michael LN88AQPilatus PC-12/47E · S/N 1029Built 2008 · Advanced Air LLCN8967MBeech 35-B33 · S/N CD-734Built 1964 · Sanocki EquitiesN8RRBellanca 7GCBC · S/N 450-73Carey Patrick TN927JCPilatus PC-12/47E · S/N 1012Built 2008 · M13 Holding LLCN97446Cessna 182Q · S/N 18267096Built 1979 · Mpm Wizard Enterprise LLC
Back to Hawthorne, CA