University Of Alabama In Huntsville
Earlier aircraft under this name · 23
Cancelled registrations that named this owner when they ended, newest first.
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'UNIVERSITY OF ALABAMA IN HUNTSVILLE' OR list_contains(d.other_registrant_names, 'UNIVERSITY OF ALABAMA IN HUNTSVILLE') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'UNIVERSITY OF ALABAMA IN HUNTSVILLE' OR list_contains(d.other_registrant_names, 'UNIVERSITY OF ALABAMA IN HUNTSVILLE') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
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.
N950UAUniv Of Alabama AT Huntsville PEGASUS · S/N MAE 2016-005N7843HRotomotion SR-20 · S/N 237N784RADJI FLAMEWHEEL F450 · S/N RC2016-001N793TADJI PHANTOM 3 STANDARD · S/N P5AJDC01020862N794AHUniv Of Alabama IN Huntsville FLAMEWHEEL 550 · S/N RC2016-003N784WADJI INSPIRE 1 · S/N W 130DN12060151N784XZRotomotion SR-20 · S/N 188N858FADJI SPREADING WINGS S900 · S/N 0380066569N858HADJI SPREADING WINGS S900 · S/N 0380066587N855UQDJI MATRICE 200 · S/N EH261644184398N855VDDJI INSPIRE 2 · S/N OAOLDBS00302CFN855WGDJI INSPIRE 2 · S/N OAOLDCS003006KN551BMDJI PHANTOM 2 · S/N UA2SN798QUUniv Of Alabama IN Huntsville FLAMEWHEEL 550 · S/N RC2016-004N806NUUniversity Of Alabama IN Hunts ATLAS · S/N MAE 2016-006N668DA3D Robotics SOLO · S/N 111A5900922N668KADJI PHANTOM 2 · S/N PH646059392N668RADJI PHANTOM 2 · S/N PH646059400N742EADJI FLAMEWHEEL F550 · S/N MAE 2016-004N742HADJI PHANTOM 3 STANDARD · S/N P5ADCF300100N6N742LADJI FLAMEWHEEL F450 · S/N MAE 2016-003N634QAUniversity Of Alabama IN Hunts EAGLE · S/N MAE 2016-001N634RAUniversity Of Alabama IN Hunts P-525 · S/N MAE 2016-002
Back to University Of Alabama In Huntsville