Orange, CA
Registered aircraft · 73
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 = 'ORANGE' 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.
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 = 'ORANGE' ORDER BY g.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.
N1093EBellanca 8KCAB · S/N 320-77N111LUPiper PA-28-236 · S/N 28-7911091N1158ZCessna U206G · S/N U20606634N120PVSchleicher ASW-20 · S/N 20493N123LEToomey Michael S LONG EZ · S/N 1307N14982Ryan Aeronautical ST-A · S/N 114N171LWaco Classic YMF-F5C · S/N F5C-8-134N215ZMPipistrel Italia S R L ALPHA TRAINER · S/N 949 AT 912 LSAN224RFCirrus Design SR20 · S/N 1178N22543Stinson HW75 · S/N 7106N2274DCessna 170B · S/N 20426N2334JCessna 172S · S/N 172S9995N238SFCirrus Design SR22T · S/N 9285N239CALearjet 31A · S/N 126N24512Cessna 152 · S/N 15280300N2462ECessna 172N · S/N 17271291N276MKDornier DO27A4 · S/N 383N30239Cessna 177 · S/N 17701143N30296Cessna 162 · S/N 16200096N3079Arrow Aircraft & Motors ARROW SPORT · S/N 337N311EHCessna 172N · S/N 17269158N3122LCessna 310J · S/N 310J0122N321KBCessna 337G · S/N 33701782N325KCCessna 414A · S/N 414A0825N3350SCessna 210J · S/N 21059150N33BMGrumman TBM-3E · S/N 53119N34147Cessna 177B · S/N 17701665N39LBMiller STARDUSTER-TOO-300 · S/N 1146N4183DPiper PA-32R-301T · S/N 3257203N44675Piper PA-28-140 · S/N 28-7425438N45141Gulfstream American AA-5B · S/N AA5B1006N45601Cessna 150M · S/N 15076986N510SDCessna 650 · S/N 650-0161N52UNorthcutt Robert H STARDUSTER TWO · S/N RN2N54USBeech B100 · S/N BE122N555HSCirrus Design SR22T · S/N 1575N5734VBeech 35-C33A · S/N CE-28N604WBCanadair CL-600-2B16 · S/N 5306N616RRobinson Helicopter R44 II · S/N 10787N63360Boeing B75N1 · S/N 75-6954N6414JPiper PA-28-180 · S/N 28-4831N6592RBeech B24R · S/N MC-308N66444Beech A36TC · S/N EA-12N677ZBeech 95-C55 · S/N TE-14N6855CLockheed PV-2 · S/N 151432N6868LCessna 182N · S/N 18260147N694PRCirrus Design SR22 · S/N 1606N6982WPiper PA-28-140 · S/N 28-21292N700KFHelio H-700 · S/N H-10N707RBoeing A75N1(PT17) · S/N 75-544
Back to Orange, CA