Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('1383700')
ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('1383700')
ORDER BY n_numberRun 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.
N925ATDelta Air Lines Inc · Atlanta, GAN926ATDelta Air Lines Inc · Atlanta, GAN927ATDelta Air Lines Inc · Atlanta, GAN928ATDelta Air Lines Inc · Atlanta, GAN929ATDelta Air Lines Inc · Atlanta, GAN930ATDelta Air Lines Inc · Atlanta, GAN932ATDelta Air Lines Inc · Atlanta, GAN933ATDelta Air Lines Inc · Atlanta, GAN934ATDelta Air Lines Inc · Atlanta, GAN935ATDelta Air Lines Inc · Atlanta, GAN936ATDelta Air Lines Inc · Atlanta, GAN937ATDelta Air Lines Inc · Atlanta, GAN938ATDelta Air Lines Inc · Atlanta, GAN939ATDelta Air Lines Inc · Atlanta, GAN940ATDelta Air Lines Inc · Atlanta, GAN942ATDelta Air Lines Inc · Atlanta, GAN943ATDelta Air Lines Inc · Atlanta, GAN944ATDelta Air Lines Inc · Atlanta, GAN945ATDelta Air Lines Inc · Atlanta, GAN946ATDelta Air Lines Inc · Atlanta, GAN947ATDelta Air Lines Inc · Atlanta, GAN948ATDelta Air Lines Inc · Atlanta, GAN949ATDelta Air Lines Inc · Atlanta, GAN950ATDelta Air Lines Inc · Atlanta, GAN951ATDelta Air Lines Inc · Atlanta, GAN952ATDelta Air Lines Inc · Atlanta, GAN953ATDelta Air Lines Inc · Atlanta, GAN954ATDelta Air Lines Inc · Atlanta, GAN955ATDelta Air Lines Inc · Atlanta, GAN957ATDelta Air Lines Inc · Atlanta, GAN959ATDelta Air Lines Inc · Atlanta, GAN960ATDelta Air Lines Inc · Atlanta, GAN961ATDelta Air Lines Inc · Atlanta, GAN963ATDelta Air Lines Inc · Atlanta, GAN964ATDelta Air Lines Inc · Atlanta, GAN965ATDelta Air Lines Inc · Atlanta, GAN966ATDelta Air Lines Inc · Atlanta, GAN967ATDelta Air Lines Inc · Atlanta, GAN970ATDelta Air Lines Inc · Atlanta, GAN971ATDelta Air Lines Inc · Atlanta, GAN974ATDelta Air Lines Inc · Atlanta, GAN977ATDelta Air Lines Inc · Atlanta, GAN978ATDelta Air Lines Inc · Atlanta, GAN979ATDelta Air Lines Inc · Atlanta, GAN980ATDelta Air Lines Inc · Atlanta, GAN981ATDelta Air Lines Inc · Atlanta, GAN982ATDelta Air Lines Inc · Atlanta, GAN983ATDelta Air Lines Inc · Atlanta, GAN985ATDelta Air Lines Inc · Atlanta, GAN986ATDelta Air Lines Inc · Atlanta, GA
Back to Boeing 717-200