Miloud Chadd K
Registered aircraft · 31
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
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_name = 'MILOUD CHADD K' OR list_contains(g.other_registrant_names, 'MILOUD CHADD K') 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_name = 'MILOUD CHADD K' OR list_contains(g.other_registrant_names, 'MILOUD CHADD K') 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.
N154FTPiper PA-28-161 · S/N 28-8216194N1914HPiper PA-28-161 · S/N 28-7716062N2135BPiper PA-28-161 · S/N 28-7916110N2202WPiper PA-28-161 · S/N 28-7916332N2233WPiper PA-28-161 · S/N 28-7916335N2236WPiper PA-28-161 · S/N 28-7916337N32574Piper PA-28-151 · S/N 28-7515191N32588Piper PA-28-151 · S/N 28-7515195N43037Piper PA-28-161 · S/N 28-8316068N43408Piper PA-28-161 · S/N 28-8416048N44555Piper PA-28-151 · S/N 28-7415667N44AEPiper PA-34-200T · S/N 347870240N47615Piper PA-28-161 · S/N 28-7816105N5437JCessna 172N · S/N 17273794N6281CPiper PA-28-161 · S/N 28-7816403N777JRPiper PA-34-200 · S/N 34-7350093N797KMBeech 95 · S/N TD-282N8097HPiper PA-28-161 · S/N 28-8016092N8135GPiper PA-28-161 · S/N 28-8016175N8137UPiper PA-28-161 · S/N 28-8016181N81981Piper PA-28-161 · S/N 28-8216147N82075Piper PA-28-161 · S/N 28-8216158N8283VPiper PA-28-161 · S/N 28-8116065N8387RPiper PA-28-140 · S/N 28-22264N8405BPiper PA-28-161 · S/N 28-8116252N8691EPiper PA-34-200T · S/N 34-7670166N9062KPiper PA-28-161 · S/N 28-7816187N911UAPiper PA-28-140 · S/N 28-20262N9358CPiper PA-28-161 · S/N 28-7816466N969WAPiper PA-34-200T · S/N 348070112N977LBPiper PA-34-200T · S/N 34-7670243
Back to Miloud Chadd K