Ryan Air Inc
Registered aircraft · 27
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 = 'RYAN AIR INC' OR list_contains(g.other_registrant_names, 'RYAN 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 = 'RYAN AIR INC' OR list_contains(g.other_registrant_names, 'RYAN 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.
N1331CConstrucciones Aeronauticas C-212-CC · S/N 265N219PCPilatus PC-12/45 · S/N 219N26TACessna 207A · S/N 20700725N348CAConstrucciones Aeronauticas C-212-CC · S/N 175N352CAConstrucciones Aeronauticas C-212-CC · S/N 190N410WRPilatus PC-12/47 · S/N 818N424CAConstrucciones Aeronauticas CASA-212-200 · S/N 242N439RAConstrucciones Aeronauticas CASA-212-200 · S/N 287N440RAConstrucciones Aeronauticas C-212-CC · S/N 174N624DRCessna 207A · S/N 20700517N624ERCessna 207A · S/N 20700752N704RATextron 208B · S/N 208B5814N707RACessna 208B · S/N 208B5120N708RATextron 208B · S/N 208B5606N709RATextron 208B · S/N 208B5436N7305UCessna T207A · S/N 20700392N73217Cessna 207A · S/N 20700572N73467Cessna T207A · S/N 20700594N73503Cessna 207A · S/N 20700599N73789Cessna T207A · S/N 20700629N7605UCessna 207A · S/N 20700443N906RASaab-Fairchild 340A · S/N 340A-109N907RASaab-Fairchild 340A · S/N 340A-111N9475MCessna 207A · S/N 20700695N9736MCessna 207A · S/N 20700722N9829MCessna 207A · S/N 20700741N9956MCessna 207A · S/N 20700763
Back to Ryan Air Inc