OpenAirDocs.org
Lake Forest, CA

Registered aircraft · 31

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 = 'LAKE FOREST'
  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.

N102KAKarem TR-8 · S/N 00002Karem Aircraft IncN110SMCessna 337 · S/N 337-0023Built 1964 · Penhall Michael JosephN122MBCirrus Design SR22T · S/N 8607Built 2022 · Suncrest Industries IncN15540Bowlus BA-100 · S/N 115Feher Ernest VN2106LBeech A36 · S/N E-878Built 1976 · Cht CorpN24DASchempp-Hirth NIMBUS 3/24.5 · S/N 47Built 1983 · Feher Ernest VN2957NPiper PA-32-300 · S/N 32-7940228Built 1979 · Bak John AN30463Cessna 177A · S/N 17701271Built 1968 · Chambers Frederick JN3190PBell Helicopter Textron 206L-1 · S/N 45779Built 1983 · Veturis DavidN327SBSchultz Christopher A SCHULTZ THORP T-18 · S/N 01573-SBBuilt 2014 · Schultz Christopher AN362ZKKarem TR-8 · S/N 00001Karem Aircraft IncN380MCHughes 269A · S/N 128-1054Veturis David LN40HWRolladen-Schneider LS-3 · S/N 3279Built 1978 · Burrows ErikN477DMKarem TR-8 · S/N 00003Karem Aircraft IncN488JFBeech A45 · S/N G-298Built 1953 · Mentoraire LLCN490YRPiper PA-46-600TP · S/N 4698096Built 2018 · Devone AdamN540CZW J Versfeld COZY MKIV · S/N 0673Built 2006 · Orr David A CN540RROsmena M/Ronneberg D/Orr D BERKUT · S/N 048Built 2018 · Orr David A CN56709Piper PA-32-300 · S/N 32-7440020Built 1973 · Vola Acosta LLCN567WTextron C90GTI · S/N LJ-2159Built 2018 · Refrigeration Supplies DistributorN5874CCessna 421 · S/N 421C0882Vola Acosta LLCN5CTPiper PA-31-310 · S/N 31-8312015Bws Industries LLCN67172Bell 206B · S/N 5118Built 1993 · Veturis DavidN6CMMatthews THORP T-18 · S/N 712First renewal noticeBuilt 1978 · Schultz Christopher AN7095QCessna 172L · S/N 17260395Built 1972 · Wong Henry L IIIN73EZCharlton L Scott BERKUT · S/N 0024Built 2007 · Orr David AcN7702LPiper PA-32R-301 · S/N 32R-8013104Built 1980 · Prp Enterprises LLCN83247Aeronca 7AC · S/N 7AC-1911Owens Russell DN95183Earthstar THUNDERGULL JT2 · S/N ETGJT253Built 1995 · Drzymkowski Mark SN999LGPiper PA-32R-301T · S/N 3257131Zhou Aviation LLCN9KMTextron 525 · S/N 525-1149Built 2023 · Refrigeration Supplies Distributor
Back to Lake Forest, CA