Paris Air Inc
Registered aircraft · 56
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 = 'PARIS AIR INC' OR list_contains(g.other_registrant_names, 'PARIS AIR INC') 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 = 'PARIS AIR INC' OR list_contains(g.other_registrant_names, 'PARIS AIR INC') 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.
N101ZWSchweizer 269C-1 · S/N 0276N11DSSchweizer 269C-1 · S/N 0323N1377HPiper PA-28-161 · S/N 28-7716019N161KMPiper PA-28-161 · S/N 28-7716136N165FTPiper PA-28-161 · S/N 28-8216195N21123Piper PA-28-161 · S/N 28-7916027N21441Piper PA-28-161 · S/N 28-7916040N2236GPiper PA-28-161 · S/N 28-7916215N2244MPiper PA-28-161 · S/N 28-7816261N259PEPiper PA-28-161 · S/N 28-7716226N277AMPiper PA-34-200 · S/N 34-7450188N2845YPiper PA-28-161 · S/N 28-7916471N2875XPiper PA-28-161 · S/N 28-7916502N2882TPiper PA-34-200 · S/N 34-7250180N2901HPiper PA-28-161 · S/N 28-7916526N29220Piper PA-28-161 · S/N 28-7916423N29222Piper PA-28-161 · S/N 28-7916426N2959QPiper PA-28-161 · S/N 28-7916585N3031WPiper PA-28-161 · S/N 28-7916348N333SEPiper PA-34-200 · S/N 34-7350091N3471MPiper PA-28-161 · S/N 28-7816346N34MYPiper PA-34-200 · S/N 34-7450088N35705Piper PA-28-161 · S/N 28-8016207N3746MPiper PA-28-161 · S/N 28-7816372N408LWPiper PA-28-161 · S/N 28-7716114N41285Piper PA-34-200 · S/N 34-7450105N4317BPiper PA-28-161 · S/N 28-8416001N4317DPiper PA-28-161 · S/N 28-8416002N43519Piper PA-34-200 · S/N 34-7450192N43885Piper PA-28-161 · S/N 28-8516032N47651Piper PA-28-161 · S/N 28-7816112N499XMPiper PA-34-200 · S/N 347250259N500LHPiper PA-28-161 · S/N 28-7916240N511BHSchweizer 269C-1 · S/N 0291N55075Piper PA-34-200 · S/N 34-7350170N56676Piper PA-34-200 · S/N 34-7450020N56686Piper PA-34-200 · S/N 34-7450021N6232HPiper PA-28-161 · S/N 28-7816240N6879CPiper PA-28-161 · S/N 28-7816437N75231Piper PA-28-151 · S/N 28-7615272N8091RPiper PA-28-161 · S/N 28-8016077N81021Piper PA-28-161 · S/N 28-8016106N8149TPiper PA-28-161 · S/N 28-8016255N82045Piper PA-28-161 · S/N 28-8216157N8217QPiper PA-28-161 · S/N 28-8016334N8254JPiper PA-28-161 · S/N 28-8216186N83009Piper PA-28-161 · S/N 28-8116088N8307YPiper PA-28-161 · S/N 28-8116100N8330LPiper PA-28-161 · S/N 28-8116141N83960Piper PA-28-161 · S/N 28-8116244
Back to Paris Air Inc