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 ('3260212')
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 ('3260212')
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.
N908AEAmerican Airlines Inc · Fort Worth, TXN909AEAmerican Airlines Inc · Fort Worth, TXN912JXDelux Public Charter LLC · Dallas, TXN913JXDelux Public Charter LLC · Dallas, TXN914JXDelux Public Charter LLC · Dallas, TXN915JXDelux Public Charter LLC · Dallas, TXN916JXDelux Public Charter LLC · Dallas, TXN917JXDelux Public Charter LLC · Dallas, TXN918AEAmerican Airlines Inc · Fort Worth, TXN918JXDelux Public Charter LLC · Dallas, TXN919JXDelux Public Charter LLC · Dallas, TXN922AEAmerican Airlines Inc · Fort Worth, TXN922JXDelux Public Charter LLC · Dallas, TXN923AEAmerican Airlines Inc · Fort Worth, TXN925AEAmerican Airlines Inc · Fort Worth, TXN926JXDelux Public Charter LLC · Dallas, TXN928AEAmerican Airlines Inc · Fort Worth, TXN928JXDelux Public Charter LLC · Dallas, TXN92VAAdvanced Air LLC · Statesville, NCN931AEAmerican Airlines Inc · Fort Worth, TXN931JXDelux Public Charter LLC · Dallas, TXN932AEAmerican Airlines Inc · Fort Worth, TXN932JXDelux Public Charter LLC · Dallas, TXN933JNAmerican Airlines Inc · Fort Worth, TXN933JXDelux Public Charter LLC · Dallas, TXN934JXDelux Public Charter LLC · Dallas, TXN935AEAmerican Airlines Inc · Fort Worth, TXN935JXDelux Public Charter LLC · Dallas, TXN937JXDelux Public Charter LLC · Dallas, TXN939AEAmerican Airlines Inc · Fort Worth, TXN940JXDelux Public Charter LLC · Dallas, TXN941LTAmerican Airlines Inc · Fort Worth, TXN942LLAmerican Airlines Inc · Fort Worth, TXN947JXDelux Public Charter LLC · Dallas, TXN948JXDelux Public Charter LLC · Dallas, TXN949JXDelux Public Charter LLC · Dallas, TXN950JXDelux Public Charter LLC · Dallas, TXN952JXDelux Public Charter LLC · Dallas, TXN954JXDelux Public Charter LLC · Dallas, TXN955JXDelux Public Charter LLC · Dallas, TXN956JXDelux Public Charter LLC · Dallas, TXN957JXDelux Public Charter LLC · Dallas, TXN958JXDelux Public Charter LLC · Dallas, TXN959JXDelux Public Charter LLC · Dallas, TXN960JXDelux Public Charter LLC · Dallas, TXN961JXDelux Public Charter LLC · Dallas, TXN962JXDelux Public Charter LLC · Dallas, TXN963JXDelux Public Charter LLC · Dallas, TXN970DCCbg LLC · Wilsonville, ORN971DCCbg LLC · Wilsonville, OR
Back to Embraer EMB-145LR