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 ('06102I0')
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 ('06102I0')
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.
N358JPCape May Aerial Advertising LLC · Rio Grande, NJN358LPCape May Aerial Advertising LLC · Rio Grande, NJN358MPCape May Aerial Advertising LLC · Rio Grande, NJN358QJCape May Aerial Advertising LLC · Rio Grande, NJN358RPCape May Aerial Advertising LLC · Rio Grande, NJN358THCape May Aerial Advertising LLC · Rio Grande, NJN358UTCape May Aerial Advertising LLC · Rio Grande, NJN358WTCape May Aerial Advertising LLC · Rio Grande, NJN358XECape May Aerial Advertising LLC · Rio Grande, NJN358YKCape May Aerial Advertising LLC · Rio Grande, NJN358ZVCape May Aerial Advertising LLC · Rio Grande, NJN359BBCape May Aerial Advertising LLC · Rio Grande, NJN3600CCape May Aerial Advertising LLC · Rio Grande, NJN3601KCape May Aerial Advertising LLC · Rio Grande, NJN3602CCape May Aerial Advertising LLC · Rio Grande, NJN3605VCape May Aerial Advertising LLC · Rio Grande, NJN3607CCape May Aerial Advertising LLC · Rio Grande, NJN3608CCape May Aerial Advertising LLC · Rio Grande, NJN3609CCape May Aerial Advertising LLC · Rio Grande, NJN360QCCape May Aerial Advertising LLC · Rio Grande, NJN360UCCape May Aerial Advertising LLC · Rio Grande, NJN360VBCape May Aerial Advertising LLC · Rio Grande, NJN360XCCape May Aerial Advertising LLC · Rio Grande, NJN360YQCape May Aerial Advertising LLC · Rio Grande, NJN360ZLCape May Aerial Advertising LLC · Rio Grande, NJN361FCCape May Aerial Advertising LLC · Rio Grande, NJN361GDCape May Aerial Advertising LLC · Rio Grande, NJN361HNCape May Aerial Advertising LLC · Rio Grande, NJN361JKCape May Aerial Advertising LLC · Rio Grande, NJN361LECape May Aerial Advertising LLC · Rio Grande, NJ
Back to Verge X7