California, MD
Registered aircraft · 47
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 = 'MD' AND g.registrant_city = 'CALIFORNIA' 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 = 'MD' AND g.registrant_city = 'CALIFORNIA' 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.
N1051RZobell Edward Alexandre AC-4KC · S/N 005N11120Nicholas Bachert ROTORWAY A600 · S/N 0025N130RLBeech 200T · S/N BT16N14MLLardner Martin E BARRACUDA · S/N 350N150RLBeech B200C · S/N BL-50N15BTSchleicher ASW-15 · S/N 15236N161PRDouglas DC3C · S/N 32843N170RLBeech 200T · S/N BT28N17295Cessna 150L · S/N 15073708N1856AEdge Autonomy PENGUIN-B · S/N PNB1031N2014MEdge Autonomy PENGUIN-B · S/N PNB1030N2114KPiper PA-28-181 · S/N 28-7990235N2232ZBellanca 17-31ATC · S/N 76-31135N2256XCessna 337 · S/N 337-0156N242TTUrban Air Sro UFM-13 LAMBADA · S/N 111/13N286ATTextron 208B · S/N 208B5227N287ATRaytheon B300 · S/N FL-430N288ATBeech 300 · S/N FA134N289ATBeech B300 · S/N FL-65N3019Glasflugel STANDARD LIBELLE · S/N 44N32519Bachert Nicholas T RV-10 · S/N 41353N33124Piper PA-28-235 · S/N 28-7510039N349PHDehavilland DHC-8-202 · S/N 486N41LCCessna 310Q · S/N 310Q0502N420UCessna 172R · S/N 17280120N450PRDeutch Ronald J JABIRU J450 · S/N 0139N4784MBeech 95-B55 (T42A) · S/N TC-2145N5222TCessna 337G · S/N 33701655N531AMCessna 310G · S/N 310G0097N5759PPiper PA-24 · S/N 24-836N618TBNorris Randall L ZODIAC 650B · S/N 65-8781N6510MStinson 108-3 · S/N 108-4510N678PRPrevost Guy E RV-8A · S/N 82273N720CBeech A100 · S/N B-171N733SKCessna 172N · S/N 17268511N8234APiper PA-28-161 · S/N 28-8016351N8355MCessna A150K · S/N A1500055N844THDouglas DC3C-S1C3G · S/N 13070N84801Cessna 172K · S/N 17258617N8789HRyan NAVION A · S/N NAV-4-789N881GLBritten-Norman BN-2A-26 · S/N 84N900KBBeech 58 · S/N TH-863N9191UCessna 150M · S/N 15078142N9273SBeech C23 · S/N M-1759N945TSNavmar Applied Sciences TIGERSHARK BLOCK II · S/N 145N949SPCessna 172S · S/N 172S8145N9MAValentin TAIFUN 17E · S/N 1090
Back to California, MD