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.
N355KPCape May Aerial Advertising LLC · Rio Grande, NJN355LCCape May Aerial Advertising LLC · Rio Grande, NJN355NTCape May Aerial Advertising LLC · Rio Grande, NJN355QCCape May Aerial Advertising LLC · Rio Grande, NJN355RPCape May Advertising LLC · Rio Grande, NJN355TBCape May Aerial Advertising LLC · Rio Grande, NJN355UUCape May Aerial Advertising LLC · Rio Grande, NJN355VWCape May Aerial Advertising LLC · Rio Grande, NJN355WVCape May Aerial Advertising LLC · Rio Grande, NJN355XWCape May Aerial Advertising LLC · Rio Grande, NJN355YVCape May Aerial Advertising LLC · Rio Grande, NJN355ZXCape May Aerial Advertising LLC · Rio Grande, NJN3560KCape May Aerial Advertising LLC · Rio Grande, NJN3562PCape May Aerial Advertising LLC · Rio Grande, NJN356BJCape May Aerial Advertising LLC · Rio Grande, NJN356ECCape May Aerial Advertising LLC · Rio Grande, NJN356FPCape May Aerial Advertising LLC · Rio Grande, NJN356GDCape May Aerial Advertising LLC · Rio Grande, NJN356HZCape May Aerial Advertising LLC · Rio Grande, NJN356KPCape May Aerial Advertising LLC · Rio Grande, NJN356NECape May Aerial Advertising LLC · Rio Grande, NJN356PPCape May Aerial Advertising LLC · Rio Grande, NJN356QFCape May Aerial Advertising LLC · Rio Grande, NJN356RECape May Aerial Advertising LLC · Rio Grande, NJN356SGCape May Aerial Advertising LLC · Rio Grande, NJN356UTCape May Aerial Advertising LLC · Rio Grande, NJN356VPCape May Aerial Advertising LLC · Rio Grande, NJN356WHCape May Aerial Advertising LLC · Rio Grande, NJN356XACape May Aerial Advertising LLC · Rio Grande, NJN356YPCape May Aerial Advertising LLC · Rio Grande, NJN356ZJCape May Aerial Advertising LLC · Rio Grande, NJN3576PCape May Aerial Advertising LLC · Rio Grande, NJN3578QCape May Aerial Advertising LLC · Rio Grande, NJN357FKCape May Aerial Advertising LLC · Rio Grande, NJN357GLCape May Aerial Advertising LLC · Rio Grande, NJN357HLCape May Aerial Advertising LLC · Rio Grande, NJN357KTCape May Aerial Advertising LLC · Rio Grande, NJN357NMCape May Aerial Advertising LLC · Rio Grande, NJN357QPCape May Aerial Advertising LLC · Rio Grande, NJN357TJCape May Aerial Advertising LLC · Rio Grande, NJN357UNCape May Aerial Advertising LLC · Rio Grande, NJN357VGCape May Aerial Advertising LLC · Rio Grande, NJN357XPCape May Aerial Advertising LLC · Rio Grande, NJN357YPCape May Aerial Advertising LLC · Rio Grande, NJN357ZFCape May Aerial Advertising LLC · Rio Grande, NJN3588TCape May Aerial Advertising LLC · Rio Grande, NJN358AYCape May Aerial Advertising LLC · Rio Grande, NJN358BRCape May Aerial Advertising LLC · Rio Grande, NJN358DPCape May Aerial Advertising LLC · Rio Grande, NJN358GECape May Aerial Advertising LLC · Rio Grande, NJ
Back to Verge X7